got error 22 from storage engine mysql

Question

mysqldump: Error: 'got error 22 from storage engine' when trying to dump tablespaces mysqldump: Got error: 23: Out of resources when opening file '.\database\table.MYD' (Errcode: 24) when using LOCK TABLES

i got this error when trying to make a dump in any database that I select , looks like that database is corrupted , is possible repair that ?

Answer 1

You seem to have reached the maximum number of open files. This limit is either MySQL's or the system's.

• increase the value for the open_files_limit in your MySQL configuration file (this directive does not exist in a default installation, so you might need to create it in the [mysqld] section)

• increase the limit at system level (but I am not sure this applies to Windows)

Answer 2

Please check your read write access to the drive where you have stored your mySQL database. error 22 occurred usually when you have no write access to that drive.

Answer 3

Here are some reasons for this error:

Type “source path-to-SQL-file“. BUT, you must follow these rules:

• Use the full source command, not the . shortcut.
• Have no spaces in your path. I copied mine to a root of a drive. Note that spaces in the file name is OK, just not the path.
• Do not quote the file name, even if it has spaces. This gave error 22.
• Use forward slashes in the path, e.g., C:/path/to/filename.sql. Otherwise you’ll get error 2.
• Do not end with a semicolon.