New answers tagged corruption
mysqlcheck won't fix corruption in InnoDB table. You need to dump data from the table and re-create it. Start MySQL with innodb_force_recovery option. Try values from 1 to 6 until MySQL starts. Dump the table with mysqldump. Drop the table. Restart MySQL w/o innodb_force_recovery. Reload the dump.
pg_basebackup and other methods like pg_dump might not actually finish due to the corruption, and you really need that backup in that case. Being independent of PostgreSQL and its tools, tar is not as likely to run into those issues. In the case of corruption, that backup will be an invaluable insurance policy when you try to recover your data or do ...
Top 50 recent answers are included