CODEWITHSUNDEEP
windowsmysql
user2729306
user2729306

Reputation: 41

got error 22 from storage engine mysql

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 ?

Upvotes: 4

Views: 9808

Answers (3)

Diego Victor de Jesus
Diego Victor de Jesus

Reputation: 3003

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.

Upvotes: 2

shakeel ansari
shakeel ansari

Reputation: 11

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.

Upvotes: 1

RandomSeed
RandomSeed

Reputation: 29759

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)

Upvotes: 2

Related Questions