MySQL data backup out of opening file error

Today, using the command to export the database for recovery on the new VPS, a situation occurs:

Error message:

Mysqldump:got error:23:out of opening file './zrblog_dfhghdt/pre_ucenter_settings. MyD ' (errcode:24) when using LOCK TABLES

First use the Ulimit-n command to view the number of open file limits:

ROOT@ZR [~]# Ulimit-n
1024

We need to adjust the value of Open_files_limit in the MySQL configuration file

Edit my.cnf (instruction Vi/etc/my.cnf), I have no open_files_limit here,

Just increase the value of it.

My original is Open_files_limit = 600

Later to be modified into open_files_limit = 1024

Save it when you are done, restart MySQL, and then try the backup of our initial command.

OK, it's done.

Of course, there is another way to backup, such as we use the Professional Backup tool or package MySQL in the Data directory files