MySQL Forums
Forum List  »  Backup

Mysqldump point in time recovery.
Posted by: Antonis Giannopoulos
Date: September 12, 2013 07:12AM

I have a mysql instance with 50 databases, binary log is enable. I get a backup every night using mysqldump for 15 of these dbs, using --single transaction and the --master-data to get the current binlog position.
In case i want to restore one database using point in time with the binlogs, if i apply the bin logs what going to happen to other dbs? Mysql will re-run the same statements for all databases? Is there any other approach to suggest on that scenario?

Thank you in advance

Options: ReplyQuote

Written By
Mysqldump point in time recovery.
September 12, 2013 07:12AM
September 16, 2013 10:41PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.