Sudden start problem with mysql
I use mysql for a web gallery, but yesterday it seems to stop working, so I tried to restart mysql and webserver, but mysql fail to start. The syslog have the following info about it:
Quote:
I run the above on a Debian 4 server. TIA |
Have you check the /var/log/mysql directory, and the /var/run/mysqld directory? Are they there, and have they changed?
Also, check your MySQl configuration file, and see where it stores database files. Off the top of my head I don't remember, but I think it may be /var/spool/mysql, but please verify. Make sure that the directory exists. If it got nuked, you'll lose everything. |
By default, mysql database files will reside in /var/lib/mysql
You need to check your mysql log files to find out the problem. But these lines are of concern: Code:
Jul 22 13:11:12 webserver mysqld[3590]: ^G/usr/sbin/mysqld: Can't read dir of '/tmp/' (Errcode: 13) |
Does the ^G stand for 'bell'?
Both error messages are equally disturbing. Why would mysql not be able to read on /tmp? Check the permissions in the /tmp dir. The sticky bit must be set. This is how it should look like: drwxrwxrwt 11 root root 11264 2008-07-22 21:06 /tmp Did you check whether none of yours disks is full? Or inaccessible? Or not mounted? Or damaged? Don't worry about the mysql-bin.index. It is not very important for your database, only if you want to roll back transactions. If mysql insists of having this file, I guess you could create an empty file. Or, if there are still file in that directory, put the file list in: Code:
/var/log/mysql/mysql-bin.000158 jlinkels |
Thanks for all answers, but all seems ok when I check.
The log says that it couldn't read the /tmp, ^G/usr/sbin/mysqld: Can't read dir of '/tmp/' (Errcode: 13) My /tmp is as it should, as seen below Quote:
Quote:
Quote:
Quote:
Quote:
|
What does your mysql logs indicate if any instead of the syslog logs?
|
That's also strange, since they are empty,
Quote:
Quote:
|
To continue checking I made a new mysql install on another Debian Etch server, and then compared all mysql files, and I can't figure out what the problem could be anyway.
Any more hints... anyone? |
All times are GMT -5. The time now is 05:32 AM. |