Tell me more ×
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.
up vote 0 down vote favorite

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
1  
That is NOT the kind of questions we answer here, see stackoverflow.com/faq – Matteo Tassinari Oct 22 '12 at 11:18

migrated from stackoverflow.com Oct 22 '12 at 12:31

1 Answer

up vote -1 down vote

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.