MySQL slave table crashed, how to fix it?
Posted on 2012-12-31
I have a corrupt MySQL slave table, it says:
table is marked as crashed and last repair failed
Of course, when i ran repair statement, it still showed: Corrupt
My purpose is to quickly restore the slave table. Since master table is good, my question is can i use one of the two options listed below:
1. Drop slave table, stop and start slave again, will replication automatically restore the slave table? (previously the replication was working fine)
2. Drop slave table, use mysqldump to dump the master table to slave table (suppose there is not much traffic at this time).
Thanks for any suggestion.