Last updated on MAY 15, 2016
Applies to:MySQL Server - Version 4.0 and later
Information in this document applies to any platform.
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: 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms