My Oracle Support Banner

MySQL Cannot Find InnoDB Tables After Restart + InnoDB Tablespace Missing + InnoDB: a New Database to be Created (Doc ID 1333177.1)

Last updated on OCTOBER 16, 2017

Applies to:

MySQL Server - Version 4.0 and later
Information in this document applies to any platform.

Symptoms

On a Linux/Unix platform after restarting MySQL, InnoDB fails to find any of the tables, everything was working before the restart, and the error log contains an error like:

InnoDB: The first specified data file /var/lib/mysql/ibdata1 did not exist:
InnoDB: a new database to be created!
110627 10:00:00 InnoDB: Setting file /var/lib/mysql/ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...


If innodb_file_per_table is used, the *.idb files for the tables are still there.

Another symptom can be that the ibdata1 file is missing from the latest backups, although this might not necessarily be the case.

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
 Recovery:
 Solution 1 - Recovering from a Backup
 Solution 2 - Transportable Tablespaces
 Solution 3 - Restoring the InnoDB Tablespace
 Preventing future incidents and avoid manual recovery
References


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