Mysql won't start. When I tell it to (/etc/rc.d/init.d/mysql start) I get:

[root admin]# /etc/rc.d/init.d/mysql start
[root admin]# touch: /home/mysql/www.xfront.com.err: No such file or directory
chown: /home/mysql/www.xfront.com.err: No such file or directory
Starting mysqld daemon with databases from /home/mysql
/usr/bin/safe_mysqld: /home/mysql/www.xfront.com.err: No such file or director
y
/usr/bin/safe_mysqld: /home/mysql/www.xfront.com.err: No such file or director
y
tee: /home/mysql/www.xfront.com.err: No such file or directory
020215 02:43:01 mysqld ended
tee: /home/mysql/www.xfront.com.err: No such file or directory


Any ideas? Thanks in advance. (note, url given changed for security reasons)

Did this error occured after a upgrade/ reinstall ???

Where did you install MYSQL ? Is it from source or from a supplied *.pkg from cobalt ??

Completely random, mysql just dissappeared after a reboot. No /home/mysql/ folder.

Any way to save the data bases?

Well, I believe saving the databases is as simple as copying the entire MySQL data-directory to a safe location. You can specify any location for the datadirectory through the my.cnf file. Maybe it picks up on the right location right away when you reinstall.
If not, look at the location in the my.cnf file, change it if necessary and restart MySQL.

It should be this simple...

If you have a my.cnf (probable in /etc) then check the settings for where the datadir might be hiding and copy it (mine is /var/lib/mysql)

Originally posted by raqman
Completely random, mysql just dissappeared after a reboot. No /home/mysql/ folder.

Any way to save the data bases?

Yes there is an easy way if you use phpmyadmin, just make a dump of all your databases including the fields and content in the fields.

A good thing is to create this on a regular basis from a cronjob. Trust me that is the best way to do it. I have learned from terrible experience (lost a whole website once by a simple click and no current backup database ofcourse... :-( )

Do you have a copy of your cronjob script that dumps the info from your databases?

-dr