Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

MySQl Slave replication server got crashed and I am missing around 60 tables, some table structure and data which present in master and by DB size is more than 25Gb, How I Can restore to resolve issue. Please help to solve it ASAP. Thanking you in advance... Nikhil

share|improve this question

migrated from Oct 22 '12 at 12:31

This question came from our site for professional and enthusiast programmers.

That is NOT the kind of questions we answer here, see – Matteo Tassinari Oct 22 '12 at 11:18

You need to restore the data from master.

  1. Take a dump of missing tables from master using

    mysqldump --singl-transaction>missing_tables.sql

  2. Stop the slave.
  3. Restore the dump file in slave using

    mysql -uroot -p<missing_tables.sql

  4. Start the replication slave will catchup.
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.