MySQL Enterprise Backup Can't Backup ibdata1: "error: creation of file ibdata1.ibz failed. error code: 17, file exists"
Last updated on AUGUST 02, 2017
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.
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