Cannot Reset LSNs, Tablespace Not Found When Restoring TTS Backup
Last updated on MARCH 08, 2017
Applies to:MySQL Enterprise Backup - Version 3.9 and later
Information in this document applies to any platform.
Restoring from a backup taken with MEB and the --use-tts parameter results in an error:
mysqlbackup: ERROR: mysql query: 'ALTER TABLE 'dbName'.'tableName' IMPORT TABLESPACE': Internal error: Cannot reset LSNs in table '"dbName"."tableName"' : Tablespace not found
The MySQL error log contains statements like:
InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
[ERROR] InnoDB: Trying to import a tablespace, but could not open the tablespace file ./dbName/tableName.ibd
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms