· 11 years ago · Jun 26, 2015, 10:59 AM
102(xiambax02) haha now that i changed my admin pass i get this error from the mamp admin site haha
202(HighFive02) i thought indexing numbers wasn't necessary indexed the rest though :P
302(seekwill02) It's funny when you said "the table is indexed" when it wasn't...
402(obnauticus02) if someone could help me with this problem..
502(obnauticus02) mysqladmin: connect to server at 'localhost' failed
602(obnauticus02) error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
702(obnauticus02) Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
8 02 —›12 quit: 02(12nst02)12 02(12i=nst@201-40-155-247.smace701.dsl.brasiltelecom.net.br02)12 02(12Connection timed out02)12
902(obnauticus02) thbat would be cool.
1002(xiambax02) Error: Could not connect to MySQL server!
1102(obnauticus02) ...
1202(obnauticus02) [root@ /home/aao_pwner]# mysqladmin stop
1302(seekwill02) Unnecessary indexing can slow down your server.
1402(obnauticus02) it does the same for start
1502(seekwill02) obnauticus: Stop flooding
1602(obnauticus02) i did?
1702(seekwill02) 8 Lines!
1802(predder02) HighFive, careful adding indexes if your application is live. You'll have to read-lock the table while the indexes are re-created depending on your version
1902(obnauticus02) your point?
2002(seekwill02) obnauticus: BTW, did you read what it suggested you to do?
2102(seekwill02) obnauticus: My point is that you flooded and I asked you to stop.
2202(obnauticus02) lol
2302(obnauticus02) i'm pastbining it all right now
2402(obnauticus02) and yes i saw it
2502(obnauticus02) http://pastebin.ca/279644
2602(seekwill02) Did you do what it said or did you just read it?
2702(obnauticus02) I'm trying to start it.
2802(obnauticus02) and it gives me that error
29 02 —›12 join: 02(12coder_502)12 02(12n=coder_5@dslb-088-073-185-078.pools.arcor-ip.net02)12
3002(obnauticus02) So i don't know what to say.
3102(HighFive02) Affected rows: 2 (Query took 0.0005 sec) well 15 seconds became 0.0005 seconds way cool... thanks guys
3202(xiambax02) haha fixed that errorz :D
3302(coder_502) hi! i'm new to databases, and wonder how to realize "tables of tables" using sql. my understanding is to create those subtables using Create Table with unique names, and store this tablenames into an indextable. am i right?
3402(seekwill02) How did you try to start it?
3502(obnauticus02) the command is IN THERE
3602(obnauticus02) mysqladmin start
3702(seekwill02) That is not how you start it.
3802(obnauticus02) how do i start it then lo.
3902(seekwill02) Read the installation instructions
4002(obnauticus02) It's been installed for the past like 6 months.
4102(seekwill02) Depends on how you installed it.
4202(seekwill02) Your point?
4302(obnauticus02) It's been working fine until now..
4402(obnauticus02) for some reason
45 02 —›12 join: 02(12spangles02)12 02(12n=edd@eddland.plus.com02)12
46 02 —›12 part: 02(12coder_502)12 02(12n=coder_5@dslb-088-073-185-078.pools.arcor-ip.net02)12
4702(seekwill02) What changed?
48 02 —›12 join: 02(12coder_502)12 02(12n=coder_5@dslb-088-073-185-078.pools.arcor-ip.net02)12
4902(seekwill02) What did you do to your computer?
5002(obnauticus02) erm..
5102(obnauticus02) There was a power outage
5202(seekwill02) "nothing"?
5302(coder_502) hi! i'm new to databases, and wonder how to realize "tables of tables" using sql. my understanding is to create those subtables using Create Table with unique names, and store this tablenames into an indextable. am i right?
5402(obnauticus02) and the thing went down
5502(obnauticus02) and now it's gay..
56 02 —›12 quit: 02(12spangles02)12 02(12n=edd@eddland.plus.com02)12 02(12Read error: 104 (Connection reset by peer)02)12
5702(obnauticus02) but erm i recompiled the kernel with firewalling
5802(obnauticus02) enabled.
5902(obnauticus02) Maby the port isn't opened?
60 02 —›12 join: 02(12spangles02)12 02(12n=edd@eddland.plus.com02)12
6102(xiambax02) how do i search for something in vi?
6202(seekwill02) No. You have to start it. Refer to the instructions that you used to install it.
6302(seekwill02) Most likely somewhere in /etc/rc.d
6402(obnauticus02) what would the file be calledd
6502(obnauticus02) called*
6602(seekwill02) LOOK FOR YOURSELF
6702(obnauticus02) ...
6802(obnauticus02) can you jsut tell me what the file would be nammed
6902(obnauticus02) so i can do a find
7002(seekwill02) No
7102(obnauticus02) why the hell not?
7202(obnauticus02) seriously man.
73 02 —›12 mode: 02(12ChanServ02)12 sets mode 02(12+o seekwill02)12
7402(obnauticus02) nice.
75 02 —›12 kick: 02(12obnauticus02)12 was kicked by 02(12seekwill02)12 02(12seekwill02)12
7602((
77 02 —›12 now talking in 02(12#mysql02)12
7802((
79 02 —›12 topic: 5.0.27 is GA | 5.1.14-Beta Available | www.mysql.com | Pastebin: http://hashmysql.org/paste/ | Manual Search: hashmysql.org:4180 | Wiki: hashmysql.org | Doc: http://dev.mysql.com/doc/ | Sense of humor is mandatory.
80 02 —›12 set by: archivist 02(12Tuesday, December 12th 2006, 08:04:2002)12
81 02 —›12 users: 351 users, 1 ops 02(120%02)12, 0 voiced 02(120%02)12, 350 regulars 02(12100%02)12
82 02 —›12 join synced in: 02(120.202)12 second(s)
8302((
8402(obnauticus02) Dude you're making no sense.
85 02 —›12 join: 02(12m4c302)12 02(12n=mace@CPE00112f38147f-CM0014e8868dba.cpe.net.cable.rogers.com02)12
86 02 —›12 nick: 02(12amd6402)12 is now known as 02(12bashusr02)12
87 02 —›12 quit: 02(12spanglesontoast02)12 02(12n=edd@eddland.plus.com02)12 02(12Read error: 104 (Connection reset by peer)02)12
88 02 —›12 quit: 02(12sven_oostenbrink02)12 02(12n=sven@148.243.5.11702)12 02(12Remote closed the connection02)12
8902(obnauticus02) ok dude, MySQL is started..
9002(obnauticus02) it's been started..
9102(obnauticus02) for some reason nothing can connect to it though.
9202(@seekwill02) It tells you why it cannot connect.
9302(obnauticus02) error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
9402(@seekwill02) !perror 2
9502(the_wench02) OS error code 2: No such file or directory
9602(obnauticus02) huh
9702(the_wench02) Please state the nature of your computing emergency
9802(@seekwill02) You don't have the sock file in /tmp. Look for it.
9902(coder_502) ...
100 02 —›12 part: 02(12coder_502)12 02(12n=coder_5@dslb-088-073-185-078.pools.arcor-ip.net02)12
10102(obnauticus02) hmm
10202(the_wench02) get on with it
10302(obnauticus02) Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
10402(@seekwill02) Make up your mind! Is MySQL running?
10502(obnauticus02) Yes.
10602(obnauticus02) lol.
10702(@seekwill02) How do you know?
10802(obnauticus02) ps aux?
10902(obnauticus02) mysql 65863 0.0 2.8 40500 26996 ?? SL 9:23PM 0:00.19 /usr/local/libexec/mysqld --defaults-extra-file=/var/db/mysql/my.cnf --basedir=/usr/local -
11002(@seekwill02) seekwill: You don't have the sock file in /tmp. Look for it.
11102(obnauticus02) I'm looking for it..
11202(obnauticus02) would i just copy it there?
11302(@seekwill02) No
11402(obnauticus02) Then why the hell are you telling me to look for it
11502(obnauticus02) what would i do with it
11602(@seekwill02) You would need to point your my.cnf files (the one in /var/db/mysql/ and maybe /etc) to that dir
117 02 —›12 quit: 02(12xiambax02)12 02(12n=xiambax@207-47-142-139.sktn.hsdb.sasknet.sk.ca02)12 02(12Read error: 104 (Connection reset by peer)02)12
11802(obnauticus02) also: for some reason my.cnf doe not exist in the directory that the process is apperentally using
11902(@seekwill02) Looks like you have a very corrupted system
12002(obnauticus02) reinstall mysql?
12102(@seekwill02) I would doubt a "power outage" caused this.
12202(obnauticus02) well that's what happened.
12302(@seekwill02) uh huh sure ok
124 02 —›12 quit: 02(12jorvis_02)12 02(12n=jorvis@c-69-140-217-90.hsd1.md.comcast.net02)12 02(12Read error: 110 (Connection timed out)02)12
12502(obnauticus02) seekwill..
12602(obnauticus02) 38,000 coustmers in vancouver washington today
12702(obnauticus02) went without power
12802(@seekwill02) A power outage does not change /etc to /var/db/mysql on it's own.
12902(obnauticus02) stop being a fucking asshole and just help me
13002(obnauticus02) jeasus christ.
131 02 —›12 mode: 02(12seekwill02)12 sets mode 02(12+b obnauticus!*@*02)12
132 02 —› 12This 02(12obnauticus!*@*02)12 ban affects: 02(12obnauticus02)12
133 02 —›12 kick: 02(12obnauticus02)12 was kicked by 02(12seekwill02)12 02(12seekwill02)12
134Session Close: Thu Dec 14 21:27:44 2006
135