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

May 31, 2002, 2:33 AM

Andy

Veteran / Moderator (18441 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

May 31, 2002, 3:18 AM

Andy

Veteran / Moderator (18441 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 (18441 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 (18441 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 (18441 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 (18441 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 (18441 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 (18441 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 (18441 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 (18441 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.