LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   mysql not staring (https://www.linuxquestions.org/questions/linux-server-73/mysql-not-staring-646770/)

JJX 06-03-2008 04:22 PM

mysql not staring
 
A week ago suddenly my mysql died! After this point refuses to start.
When i try to start (or restart) i get this error:

myserver:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!


I can start mysql manually bu using this command:

/usr/bin/mysqld_safe --skip-grant-tables --console
(i get no error messages to the screen)

Error logs (defined to my.cnf) doesnt have anyhthing strange (=no error messages & queries appear and function normaly if mysql start using the above command)

Reinstalling and/or upgrading disnt solve the problem
Using distro's (debian stable) my.cnf also didnt solve the problem


Any idea how to troubleshoot this?
Thanks

JJX 06-03-2008 05:15 PM

As always the problem is solved a little after the post.

The problem was the corrupted mysql DB.
For some reason mysql DB was corrupted (some FRM and/or MYI were missing).

You may restore from a backup (if exists). In case you dont have one, restore mysql table from an other mysql installation and change user passwords, permissions etc... (i dont know how safe is that)

It seems to work for now

Thanks


All times are GMT -5. The time now is 02:03 PM.