MySQL Forums
Forum List  »  Backup

mysqldump and binary log recovery issues
Posted by: dave wade
Date: December 28, 2005 04:34PM

Hey all,

Im rather new to mysql and am having a little trouble making a incremental backup functional.

I have created my backup with
mysqldump -uxxx -pxxx database --flush-logs > name.sql
then running
mysqladmin -uxxx -pxxx flush logs
This seems to work fine, restoring the name.sql works fine as well. Its when I issue
mysqlbinlog host.bin.001 | mysql -uxxx -pxxx I get an error. The error tells me that I am not using proper syntax and to check my version of sql for proper syntax. The kicker is that it seems to be in the log file. Am I out to lunch on something im doing. Any help would be fantastic.


Options: ReplyQuote

Written By
mysqldump and binary log recovery issues
December 28, 2005 04:34PM

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.