The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Issues with ignore-db-dir

Hello, I see that the ignore-db-dir option has been available since Maria 5.3.9 ( https://kb.askmonty.org/en/mariadb-539-changelog/ ) , however I am finding that MariaDB 5.5.27 is not recognizing the option. When I put "ignore-db-dir=lost+found" in the mysqld section of the my.cnf file or when I attempt to start mysqld with "/etc/init.d/mysql start --ignore-db-dir=lost+found", both times mysql fails to start with the following message:

130111 17:08:57 [ERROR] /usr/sbin/mysqld: unknown variable 'ignore-db-dir=lost+found'
130111 17:08:57 [ERROR] Aborting

Is there a patch that I was supposed to apply but haven't ? Or maybe I am misunderstanding how or where to specify the ignore-db-dir option.

For reference, the full version as reported by mysqld is:

$ mysqld --version
mysqld  Ver 5.5.27-MariaDB for Linux on x86_64 (MariaDB Server)

Thanks, -Said

Answer

This is not very surprising, because 5.3.9 (see https://kb.askmonty.org/en/mariadb-539-changelog/) was released on 02 Oct 2012, while 5.5.27 (https://kb.askmonty.org/en/mariadb-5527-changelog/) was released on 07 Sep 2012. Upgrade to at least 5.5.28, to have this feature in 5.5

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.