MySQL Forums
Forum List  »  MySQL Administrator

Re: MySQL GUI Tool - BACKUP using command line
Posted by: Barry Galbraith
Date: October 24, 2009 06:42PM

Hi Meir,

You can test your backup if you have a second (development) machine with MySQL on it. Just load your backup there.

If not, and you have made your backup with MySQL Administrator, you can restore your backup to a different database name on the production machine with Administrator.
Then use mysqlbinlog to extract the updates from the binary log file to an incremental backup file, open the new incremental backup with a text editor, and global replace the database name with the test db name, then run it into your test db with mysql commandline client.

Testing in a development environment is my preferred option.

You could also setup replication with your development environment as the replication slave.
The possibilities are endless, and only limited by your budget.

Good luck.
Barry.



Edited 2 time(s). Last edit at 10/24/2009 06:43PM by Barry Galbraith.

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL GUI Tool - BACKUP using command line
October 24, 2009 06:42PM


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.