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`
