MEB Restoring Backups Created with the --use-tts Option Failed with Error 1812, Tablespace is missing for table `dbname`.`tablename`
(Doc ID 2694030.1)
Last updated on JULY 26, 2020
Applies to:MySQL Enterprise Backup - Version 4.0 and later
When using MySQL Enterprise Backup to create partial backup with the --use-tts option and restore the backup to the same instance, if you execute the backup and restore operations with the root operating system user, the backup operation completes OK while the restore operation may fail with Error 1812: Tablespace is missing for table 'dbname'.'tablename' .
* Create a new database db1 and a new Innodb table t1 in it for test:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document