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

[Jim Clark]

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.