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.

I have a master and a slave mysql database (version 5.1). Is it possible to dump the database only on the slave side? If I do a dump with mysqldump I have a fulldump. Which files can I use for a point in time recovery? The relay logs?

Thanks and regards, Martin

share|improve this question
1  
you can pull binlog from the master with mysqlbinlog from MySQL 5.6. Or you can enable log_slave_updates and copy the binlog from the slave –  akuzminsky Mar 4 at 16:05

1 Answer 1

Steps you should follow:

a) Execute flush logs; on Slave server and Take a backup of slave server using mysqldump now new binary log will be created on slave server

b) Import the dump taken using mysqldump and after that using mysqlbinlog specify binlog file to read from till point of recovery time this will restore your slave status to a point you need to start with.

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.