MySQL Cannot Find InnoDB Tables After Restart + InnoDB Tablespace Missing + InnoDB: a New Database to be Created
(Doc ID 1333177.1)
Last updated on MARCH 17, 2019
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: 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...