-1

I need some help here (excuse me for my bad English).

mysql stopped suddenly after running for several hour. Since then I'm unable to start it. I have also restarted my computer. I get the following error message

mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed

What should I do? Any advice?

I'm using xampp 5.6.14.

Thanks.

closed as off-topic by user9517, Ward, womble Nov 26 '15 at 3:49

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions should demonstrate reasonable business information technology management practices. Questions that relate to unsupported hardware or software platforms or unmaintained environments may not be suitable for Server Fault - see the help center." – user9517, womble
If this question can be reworded to fit the rules in the help center, please edit the question.

  • Can you check, if your disk is full? If yes, then try to free up spaces and start again. – Diamant Nov 22 '15 at 10:18
  • my disk 14GB free – Hanif Bagus Guritno Nov 22 '15 at 10:24
  • Then you need to try repair the corrupt table. See here – Diamant Nov 22 '15 at 10:53
1

Stop the mysql service. navigate to the data library and repair the table

mysql myisamchk -r -v -f mysql/<DB_NAME>/<TABLE_NAME>

Don't forget to make a backup before trying to repair.

You can find more relative informations in the official documentation : http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html

  • It is strange that this table has crashed during normal workload, as it's only written on permission change which is a manual process. Before proceeding with myisamchk check your disk for errors. – sam_pan_mariusz Nov 22 '15 at 19:43

Not the answer you're looking for? Browse other questions tagged or ask your own question.