Restore only one database

Hi
How can i restore only specific database in my full backup?
I have full backup,and one of my database must be restore,
please help
urgent

2 Likes

Hi @mohsen, use xtrabackup --prepare --export to create .cfg files for each table you wish to restore. You then need to import the tablespaces.

https://www.percona.com/doc/percona-xtrabackup/LATEST/xtrabackup_bin/restoring_individual_tables.html

Do this for each table in the database.

Otherwise, you must restore the entire backup to ANOTHER server, and dump the database and import.

2 Likes