<div>
This is extremely helpful. Many thanks. <br />
<br />
If the table is MyISAM, what is the standard way to fully recreate the slave from the master without using Percona tools? Thanks!
</div>


This is extremely helpful. Many thanks.

If the table is MyISAM, what is the standard way to fully recreate the slave from the master without using Percona tools? Thanks!

<div>
<div class="content wysiwyg-content">
I have a corrupt MySQL slave table, it says: <br />
table is marked as crashed and last repair failed<br />
<br />
Of course, when i ran repair statement, it still showed: Corrupt<br />
<br />
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:<br />
1. Drop slave table, stop and start slave again, will replication automatically restore the slave table? (previously the replication was working fine)<br />
2. Drop slave table, use mysqldump to dump the master table to slave table (suppose there is not much traffic at this time). <br />
<br />
Thanks for any suggestion.
</div>
</div>


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.

MySQL slave table crashed, how to fix it?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.