MySQL Forums
Forum List  »  Backup

Restore one database from a backup using --all-databases
Posted by: Jim Clark
Date: January 11, 2006 08:21AM

I have a backup that was created using the --all-databases option.
now iam tring to restore one database but it will not let me.
does anyone know the parameter to restore the one database.
backup using
mysqldump -u xxxx --all-databases file name
it was also gzip at the same time
so the realbackup was using
mysqldump -u xxxx --all-databases | gzip > file name
This backups 40 databases we only want to restore one.

I also want to restore it to another server if that makes any difference.
Please let me know what command to use to restore one of the 40 databases.

Edited 1 time(s). Last edit at 01/11/2006 08:25AM by OpenPro Operations.

Options: ReplyQuote

Written By
Restore one database from a backup using --all-databases
January 11, 2006 08:21AM

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.