Do I need to restart MySQL after Importing from Xtrabackup

MySQL & MariaDB Percona XtraBackup
1

We are running Percona server 5.5.22 and Xtrabackup 2.0.1 right now. My question is - do I need to restart MySQL after Importing a table from a previous Export?

The document didn’t mention that at all:
www.percona.com/doc/percona-xtrabackup/xtrabackup_bin/export ing_importing_tables.html?id=percona-xtrabackup:xtrabackup:e xport_and_import#importing-the-table

In practice, however, I found out I had to restart the server after an Import. Otherwise, I can only see the table’s meta-data but a “SELECT * FROM that_table” only returns empty.

This wasn’t a problem when the server was dedicated to one group of user. Now that is being more public, having to restart for one group disrupts others.

Am I doing something wrong or miss configured something? Or the documentation mentioned above is incomplete?

Thanks,

Bing

2

A restart should not be necessary. Do you run the IMPORT TABLESPACE query?

3

Yes. I did. I don’t suppose I need to call “COMMIT” as it is a DDL