My Oracle Support Banner

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
Generic Linux

Symptoms

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' .

For example:

* Create a new database db1 and a new Innodb table t1 in it for test:

 

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.