Gossamer Forum: General: Internet Technologies: MySQL Deleted itself!

May 31, 2002, 2:33 AM

Andy

Veteran / Moderator (17364 posts)

May 31, 2002, 2:33 AM

Post #1 of 18

Shortcut

MySQL Deleted itself!

I'm not quite sure if it has deleted itself, or what....but when running;

/etc/rc.d/init.d/mysqld

I get a "No such file or directory" error message! ARGH! Does this mean something major is going on with MySQL, or is it a litle something I need to do? It was working fine for the last 2 months, and now, when I need it most it screws up Frown

Any ideas are much appreciated.

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

May 31, 2002, 3:18 AM

Andy

Veteran / Moderator (17364 posts)

May 31, 2002, 3:18 AM

Post #2 of 18

Shortcut

Re: [Andy] MySQL Deleted itself! In reply to

Update..../etc/rc.d/init.d/ exists, and within it there is a file called "mysql". I'm assuming this doesn't mean it has been deleted, but there is obviously still something wrong...anyone? Unimpressed

Thanks

Andy (mod)
andy@ultranerds.co.uk

May 31, 2002, 3:26 AM

Paul

Veteran (19537 posts)

May 31, 2002, 3:26 AM

Post #3 of 18

Shortcut

Re: [Andy] MySQL Deleted itself! In reply to

Erm if the file is called mysql then using mysqld will obviously not work Tongue

May 31, 2002, 3:46 AM

Andy

Veteran / Moderator (17364 posts)

May 31, 2002, 3:46 AM

Post #4 of 18

Shortcut

Re: [Paul] MySQL Deleted itself! In reply to

Yup, good point Tongue

I run /etc/rc.d/init.d/mysql start, but its still not running mySQL. I didn't get any errors reported...I'm assuming that 'mysql' serves a different purpose to 'mysqld', correct?

Andy (mod)
andy@ultranerds.co.uk

May 31, 2002, 3:57 AM

Andy

Veteran / Moderator (17364 posts)

May 31, 2002, 3:57 AM

Post #5 of 18

Shortcut

Re: [Paul] MySQL Deleted itself! In reply to

Mmm..there is a file in /root/mysql-3.23.49/sql/ called 'mysqld'. Would this work if I just copied it over to the other directory? I'm still confused though as to why it is deleted in the first place Unimpressed

Andy (mod)
andy@ultranerds.co.uk

May 31, 2002, 4:06 AM

Paul

Veteran (19537 posts)

May 31, 2002, 4:06 AM

Post #6 of 18

Shortcut

Re: [Andy] MySQL Deleted itself! In reply to

Hmm why not just try:

/usr/bin/safe_mysqld &

Last edited by:

Paul: May 31, 2002, 4:07 AM

May 31, 2002, 5:30 AM

Andy

Veteran / Moderator (17364 posts)

May 31, 2002, 5:30 AM

Post #7 of 18

Shortcut

Re: [Paul] MySQL Deleted itself! In reply to

What will that do?

Andy (mod)
andy@ultranerds.co.uk

May 31, 2002, 5:33 AM

Paul

Veteran (19537 posts)

May 31, 2002, 5:33 AM

Post #8 of 18

Shortcut

Re: [Andy] MySQL Deleted itself! In reply to

It will put a gigantic hole in planet earth.

(or it will start mysql)

May 31, 2002, 6:47 AM

Andy

Veteran / Moderator (17364 posts)

May 31, 2002, 6:47 AM

Post #9 of 18

Shortcut

Re: [Paul] MySQL Deleted itself! In reply to

[root@ace /root]# bash: /usr/bin/safe_mysqld: No such file or directory

Thats what I get when I run that command Frown

Andy (mod)
andy@ultranerds.co.uk

May 31, 2002, 7:01 AM

Paul

Veteran (19537 posts)

May 31, 2002, 7:01 AM

Post #10 of 18

Shortcut

Re: [Andy] MySQL Deleted itself! In reply to

So do a locate.

locate safe_mysqld

May 31, 2002, 7:10 AM

Andy

Veteran / Moderator (17364 posts)

May 31, 2002, 7:10 AM

Post #11 of 18

Shortcut

Re: [Paul] MySQL Deleted itself! In reply to

Ok, I did that, and it came up with /usr/local/mysql/bin/safe_mysqld, so I run that command, and got;

[root@ace /root]# /usr/local/mysql/bin/safe_mysqld
Starting mysqld daemon with databases from /usr/local/mysql/var
020531 15:10:24 mysqld ended

However, MySQL is still not running :( Any more ideas? I really do appreciate your help Paul Smile

Andy (mod)
andy@ultranerds.co.uk

May 31, 2002, 7:22 AM

Paul

Veteran (19537 posts)

May 31, 2002, 7:22 AM

Post #12 of 18

Shortcut

Re: [Andy] MySQL Deleted itself! In reply to

You missed the &

But thats not the cause of the error. Check your mysql error log.

May 31, 2002, 7:51 AM

Andy

Veteran / Moderator (17364 posts)

May 31, 2002, 7:51 AM

Post #13 of 18

Shortcut

Re: [Paul] MySQL Deleted itself! In reply to

>>>You missed the & <<<

I tried that, but it didn't make a difference.

What is the mysql error log file normally called? I tried searching for mysql_error.log, and mysqlerror.log and several other combinations, but couldnt find it.

Thanks

Andy (mod)
andy@ultranerds.co.uk

May 31, 2002, 8:00 AM

Paul

Veteran (19537 posts)

May 31, 2002, 8:00 AM

Post #14 of 18

Shortcut

Re: [Andy] MySQL Deleted itself! In reply to

>>What is the mysql error log file normally called?<<

fluxcombobulator.log

-or-

locate mysql.log

-or-

vi /etc/my.cnf

May 31, 2002, 8:07 AM

Andy

Veteran / Moderator (17364 posts)

May 31, 2002, 8:07 AM

Post #15 of 18

Shortcut

Re: [Paul] MySQL Deleted itself! In reply to

>>>fluxcombobulator.log <<<

Did I sense some sarcasm there? Wink

>>>locate mysql.log <<<

Didn't return anything

>>>vi /etc/my.cnf <<<

Came up with a load of weird crap;

Quote:

"/etc/my.cnf" [New File]

Andy (mod)
andy@ultranerds.co.uk

May 31, 2002, 8:59 AM

Paul

Veteran (19537 posts)

May 31, 2002, 8:59 AM

Post #16 of 18

Shortcut

Re: [Andy] MySQL Deleted itself! In reply to

Try

locate mysqld.log

too.

Otherwise, create a my.cnf file in /etc/ and add:

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Then restart mysql - if it dies check /var/log/mysqld.log

May 31, 2002, 9:15 AM

Andy

Veteran / Moderator (17364 posts)

May 31, 2002, 9:15 AM

Post #17 of 18

Shortcut

Re: [Paul] MySQL Deleted itself! In reply to

Still no luck.

Andy (mod)
andy@ultranerds.co.uk

May 31, 2002, 1:20 PM

Alex

Administrator (9387 posts)

May 31, 2002, 1:20 PM

Post #18 of 18

Shortcut

Re: [Andy] MySQL Deleted itself! In reply to

Your log is in /usr/local/mysql/data/SOMETHING.err or /usr/local/mysql/var/SOMETHING.err (where SOMETHING is your systems hostname).

Cheers,

Alex
--
Gossamer Threads Inc.