MySQL Forums
Forum List  »  Data Recovery

How to restore just one database
Posted by: Greg Hines
Date: October 28, 2010 07:31PM

Hi all,

I have a dump file that was created using mysqldump and the --all-databases option. I now need to restore just one database from that dump file using the mysql command.

I note there's a --one-database option but MySQL documentation seems to just it's not a good idea to use it:-

This option is rudimentary and should be used with care. Statement filtering is based only on USE statements.

Is there a better way?



Edited 1 time(s). Last edit at 11/02/2010 02:59PM by Greg Hines.

Options: ReplyQuote

Written By
How to restore just one database
October 28, 2010 07:31PM
October 31, 2010 07:44PM

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.