My Oracle Support Banner

Errors "Invalid (old?) Table Or Database Name 'lost+found'"; ignore-db-dir option Introduced in MySQL 5.6 (Doc ID 1511338.1)

Last updated on JUNE 13, 2023

Applies to:

MySQL Server - Version 5.5 and later
Information in this document applies to any platform.
Certain filesystems use the 'lost+found' directory as the partitions cleanup directory for managing corrupted inodes, file recovery etc. Common examples are the ext3 filesystem on Linux.


On : 5.1, 5.5, 5.6, 5.7 version, Other Technical Problem

SHOW DATABASES indicates a database named 'lost+found' which is not a real database. Any other directory under the data directory will also be treated as a database. You will also see errors like these in the error log file:



SHOW DATABASES should indicate all the valid MySQL databases, not extraneous ones.

The issue can be reproduced at will with the following steps:
1. Create a partition which has managed cleanup using 'lost+found' directory such as ext3.
2. Set the MySQL datadir option to be the new partition mount point e.g. /data
3. Run SHOW DATABASES within the MySQL client to see the 'lost+found' database show up.

The issue has the following business impact:
Due to this issue, users can be distracted as to what is a real database and what is a system directory. There are no other adverse effects.


Move the datadir to a new partition or to a directory below the root level. For other directories being treated as databases, move them out of the data directory tree.


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

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