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?
TIA
Greg
Edited 1 time(s). Last edit at 11/02/2010 02:59PM by Greg Hines.
Subject
Views
Written By
Posted
How to restore just one database
3922
October 28, 2010 07:31PM
1692
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.