Using option tables-file

MySQL & MariaDB Percona XtraBackup
1

Hello,

I would like to use the option this backup :
$ echo “mydatabase.mytable” > /tmp/tables.txt
$ innobackupex --tables-file=/tmp/tables.txt /path/to/backup

The backup is OK and completed, but I couldn’t see the paragraph to precise how to restore the backup with this option.
So, someone could tell me how to do this?

Thank you for your reply :slight_smile:

2

Hello!
I found this topic [url]Percona XtraBackup
But Is what I am therefore obliged to create all the tables like this? My goal is to save all other tables except one. This one table is saved by partition because it is too large to be backup in full. Will you might give me another solution or is it that I recreate the other tables when I restore and follow this manipulation [url]Percona XtraBackup ?

3

[url]Percona XtraBackup

Start from Preparing the Backup up to Restoring the Backup.

4

Hello,

I have already prepared the backup but to restore I had hoped another solution to avoid recreating all the tables in the tables.txt file like this :
mysql> CREATE TABLE name_p4 ( id int(11) NOT NULL AUTO_INCREMENT, name text NOT NULL, imdb_index varchar(12) DEFAULT NULL, imdb_id int(11) DEFAULT NULL, name_pcode_cf varchar(5) DEFAULT NULL, name_pcode_nf varchar(5) DEFAULT NULL, surname_pcode varchar(5) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2812744 DEFAULT CHARSET=utf8 Because I have many tables!

Regards,