MySQL Forums
Forum List  »  Newbie

Point-in-Time (Incremental) Recovery Using the Binary Log
Posted by: Gerard Roy Co
Date: September 01, 2014 12:22AM

Hi,

anyone here tried the recovery by using binlog?

Full Backup command
mysqldump --database db1name --single-transaction -h localhost -pPassword -u root --flush-logs > backup.sql

BIN LOG command to restore to database
mysqlbinlog binlog.000001 | mysql -u root -p db1name

I'm always having this error;
ERROR 1062 (23000) at line 35: Duplicate entry '147394926' for key 'PRIMARY'

Do i need to lock the tables when doing full backup?

Options: ReplyQuote




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.