MySQL Forums
Forum List  »  Backup

Re: Restore one database from a backup using --all-databases
Posted by: Ajay Sharma
Date: January 12, 2006 03:34PM

I backup the same way and since this is the first mysql backup that I'm maintaining, I didn't know any better when asked to restore only one database. Back in the MyISAM days you could just copy the binary data back over and be done with it but InnoDB doesn't allow that freedom (I'm not complaining, InnoDB is great).

Anyway, I have a dedicated backup server, so I just install mysql on there, restore the data and then dump *only* the database that I want. Then I restore that single database onto my production server and shutdown the database on my backup server.

Yes, this is a very lame solution, but it was the quickest way I knew how to do it.


PS. Now, I'm changing to a system where I have a mysql slave that's replicated. It's only purpose is to keep in sync with the main box so I can do exports. Before I start, I shutdown the slave process, dump each database to their own file, then start the slave up again. This way I get a clean consistent snapshot of all the databases in individual files.

Options: ReplyQuote

Written By
Re: Restore one database from a backup using --all-databases
January 12, 2006 03: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.