[MDEV-28202] mysqlcheck: unknown variable 'ignore-db-dirs=lost+found' Created: 2022-03-30  Updated: 2022-11-01  Resolved: 2022-11-01

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Alexander Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:
  1. cat /etc/debian_version
    9.13
  2. mysql --version
    mysql Ver 15.1 Distrib 10.7.3-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
  3. mysqlcheck --version
    mysqlcheck Ver 2.7.4-MariaDB Distrib 10.7.3-MariaDB, for debian-linux-gnu (x86_64)


 Description   

I have an own partition for mysql-datadir with EXT4. There exists the lost+found directory.
If i use mysqlcheck i get:

mysqlcheck: Error: Couldn't get table list for database #mysql50#lost+found: Can't read dir of './lost+found/' (errno: 13 "Permission denied")

If i add to my.cnf

ignore-db-dirs = lost+found

and restart database server everything seems to be fine.
But if i try to use mysqlcheck again now i get

mysqlcheck: unknown variable 'ignore-db-dirs=lost+found'



 Comments   
Comment by Denis Grilli [ 2022-09-27 ]

in my.cnf the syntax is the following (loose the plural):

ignore-db-dir=lost+found

and goes in the [mysqld] section.

Comment by Elena Stepanova [ 2022-11-01 ]

The important part here is "in the [mysqld] section" (not in e.g. [client]).

Generated at Thu Feb 08 09:58:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.