MySQL table is marked as crashed and last automatic repair failed

Question

I was repairing this table suddenly server hanged and when I returned back all tables are ok but this one showing  in use  and when I try to repair it doesn t proceed      ERROR 144 - Table    extas d47727 xzclf ads  is marked as crashed and last  automatic   repair failed    What can I do to repair it

User · Answer

I got myisamchk  error  myisam sort buffer size is too small as error    The solution  myisamchk -r -v mysql  lt DB NAME gt   lt TABLE NAME gt  --sort buffer size 2G

User · Answer

I needed to add USE FRM to the repair statement to make it work   REPAIR TABLE  lt table name gt  USE FRM

User · Answer

This is a 100  solution  I tried it myself   myisamchk -r -v -f --sort buffer size 128M --key buffer size 128M  var lib mysql databasename tabloname

User · Answer

Go to data dir and remove the Your table TMP file after repairing  lt Your table gt  table

User · Answer

I tried the options in the existing answers  mainly the one marked correct which did not work in my scenario  However  what did work was using phpMyAdmin  Select the database and then select the table  from the bottom drop down menu select  Repair table      Server type  MySQL Server version  5 7 23 - MySQL Community Server  GPL  phpMyAdmin  Version information  4 7 7

User · Answer

If this happend to your XAMPP installation  just copy global priv MAD and global priv MAI files from   xampp mysql backup mysql  to   xampp mysql data mysql

User · Answer

This was my experience resolving this issue  I m using XAMPP  I was getting the error below  Fatal error  Can t open and lock privilege tables  Table    mysql db  is marked as crashed and last  automatic   repair failed    This is what I did to resolve it  step by step   went to location C  xampp mysql  For you  location may be different  make sure you are in right file location  created backup of the data folder as data-old  copied folder  quot mysql quot  from C  xampp mysql backup pasted it inside C  xampp mysql data  replacing the old mysql folder   And it worked  Keep in mind  I have already tried around 10 solutions and they didnt work for me  This solutions may or may not work for you but regardless  make backup of your data folder before you do anything  Note  I would always opt to resolve this with repair command but in my case  i wasnt able to get mysql started at all and i wasnt able to get myisamchk command to work  Regardless of what you do  create a periodic backup of your database

User · Answer

Try running the following query   repair table  lt table name gt     I had the same issue and it solved me the problem

User · Answer

If your MySQL process is running  stop it  On Debian   sudo service mysql stop   Go to your data folder  On Debian   cd  var lib mysql  DATABASE NAME   Try running   myisamchk -r  TABLE NAME   If that doesn t work  you can try   myisamchk -r -v -f  TABLE NAME   You can start your MySQL server again  On Debian   sudo service mysql start

User · Answer

If it gives you permission denial while moving to  var lib mysql then use the following solution    cd  var lib    sudo -u mysql myisamchk -r -v -f mysql  lt DB NAME gt   lt TABLE NAME gt

[mysql] MySQL table is marked as crashed and last (automatic?) repair failed

Examples related to mysql

Examples related to repair