Bug #41981 | Filesystem .snap directory appears as a database | ||
---|---|---|---|
Submitted: | 8 Jan 2009 20:24 | Modified: | 28 Mar 2015 16:22 |
Reporter: | Gary Thornock | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: General | Severity: | S3 (Non-critical) |
Version: | 5.1.30 | OS: | FreeBSD |
Assigned to: | CPU Architecture: | Any |
[8 Jan 2009 20:24]
Gary Thornock
[9 Jan 2009 7:49]
Valeriy Kravchuk
This is a known problem (see http://dev.mysql.com/doc/refman/5.0/en/create-database.html about any directory under the data directory, for example) that should be fixed some day.
[9 Jan 2009 19:09]
Gary Thornock
This resembles the documentation referenced, but it still appears to be a new problem in that the 5.0.x series didn't do this (at least with default directories created by the OS).
[22 Oct 2010 20:01]
Kevin ultimate
This bug seems to completely break mysqldump --all mysqldump: Got error: 1102: Incorrect database name '#mysql50#.snap' when selecting the database
[3 Dec 2010 10:14]
Daniël van Eeden
This is related to bug #53797
[7 Mar 2014 10:50]
Daniël van Eeden
Isn't this fixed with the introduction of --ignore-db-dir?
[16 Oct 2014 23:57]
James Day
This is a duplicate of Bug #22615 MySQL Server incorrectly catogorizes the lost+found directory as a database The fix is the same, use the new --ignore-db-dir option that is available in 5.6.3 and later to hide any directories you want to hide. If you don't agree that it is a duplicate please let us know, else we'll tag it as duplicate and close it in a few months. James Day, MySQL Senior Principal Support Engineer, Oracle
[28 Mar 2015 16:22]
Paul DuBois
Fixed in 5.6.3. Changelog entry: mysqld now has a --ignore-db-dir option that tells the server to ignore a given name for purposes of the SHOW DATABASES statement or INFORMATION_SCHEMA tables. For example, if a MySQL configuration locates the data directory at the root of a file system on Unix, the system might create a lost+found directory there that the server should ignore. Starting the server with --ignore-db-dir=lost+found causes that name not to be listed as a database. To specify more than one name, use this option multiple times, once for each name. Specifying the option with an empty value (that is, as --ignore-db-dir=) resets the directory list to the empty list. Instances of this option given at server startup are used to set the ignore_db_dirs system variable. Make comment private