Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 stackoverflow.com Oct 22 '12 at 12:31

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

1  
That is NOT the kind of questions we answer here, see stackoverflow.com/faq –  Matteo Tassinari Oct 22 '12 at 11:18

1 Answer 1

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

 
discard

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