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 |
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. |