0

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

1
  • 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, 2014 at 16:05

1 Answer 1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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