Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
8.0.4
-
None
-
Yes
Description
Start PS8.0.13-3 and add some databases
source /home/mchawla/percona-qa/sample_db/world.sql source /home/mchawla/percona-qa/sample_db/sakila.sql
Take backup of specific databases "test sakila mysql sys". Exclude the databases world and performance_schema from backup.
./xtrabackup --user=root --password='' --backup --databases='test sakila mysql sys' --target-dir=$HOME/dbbackup_PS8 -S $HOME/PS201218-percona-server-8.0.13-3-linux-x86_64-debug/socket.sock --datadir=$HOME/PS201218-percona-server-8.0.13-3-linux-x86_64-debug/data
Prepare the backup
./xtrabackup --prepare --target-dir=$HOME/dbbackup_PS8
Stop PS and move the data dir to another location.
Restore the backup
./xtrabackup --copy-back --target-dir=$HOME/dbbackup_PS8 --datadir=$HOME/PS201218-percona-server-8.0.13-3-linux-x86_64-debug/data
Start PS. The following errors are displayed in logs for world database:
2019-01-03T05:27:57.930193Z 1 [Warning] [MY-012351] [InnoDB] Tablespace 2, name 'world/City', file './world/City.ibd' is missing! 2019-01-03T05:27:57.930227Z 1 [Warning] [MY-012351] [InnoDB] Tablespace 3, name 'world/Country', file './world/Country.ibd' is missing! 2019-01-03T05:27:57.930241Z 1 [Warning] [MY-012351] [InnoDB] Tablespace 4, name 'world/CountryLanguage', file './world/CountryLanguage.ibd' is missing!
Observation:
There are no errors displayed for performance_schema. The PS recreates the database and all tables, but no database files are created in data directory.