mysqldump: Error 1194

I’ve used MySql for a number of years and never incurred an error with mysqldump until today.  Fortunately there is an easy solution to the problem.

mysqldump: Error 1194: Table ‘comments’ is marked as crashed and should be repaired when dumping table `comments` at row: 12o

MySql provides a “repair table `table_name`” command to fix it.  In my case I logged into the mysql database and executed the following commands.

mysql>  use mydb;

mysql> repair table `comment`

About admin

Richard has worked in the Information Technology field for 25 years on a variety of platforms and lines of business.
This entry was posted in Uncategorized. Bookmark the permalink.