Re: Restore one database from a backup using --all-databases

[Ajay Sharma]

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.

--Ajay

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.