MySQL Enterprise Backup Can't Backup ibdata1: "error: creation of file ibdata1.ibz failed. error code: 17, file exists"
(Doc ID 2202774.1)
Last updated on MARCH 24, 2019
Applies to:MySQL Enterprise Backup - Version 4.0 and later
Information in this document applies to any platform.
A backup created using MySQL Enterprise Backup and then restored onto a system, failed due to error reporting duplicated ibdata1 system tablespace file.
The issue may start after either:
- Having innodb_data_home_dir set to different value than datadir and the MySQL instance has been restored from a MySQL Enterprise Backup backup.
- A general tablespace named 'ibdata1' has been created.
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