Question Migration Unable to copy content of database Too many open files

[heopas]

I am trying to migrate a huge website from cpanel to plesk. This website is a WordPress multisite that allows users to create their own blog. Wordpress multisite create new tables for each new user and blog, this is how it works. I have set open-files-limit to 65535 on both servers but I am getting the following error in migration.

stderr: mysqldump: Got error: 1030: "Got error 24 "Too many open files" from storage engine MyISAM" when using LOCK TABLES

 

[Bitpalast]

Some suggestions:

Increase the general maximum file descriptor value. Edit /etc/sysctl.conf and add/modify:
fs.file-max = 65535

Edit /etc/security/limits.conf and add:
mysql soft nofile 65535
mysql hard nofile 65535

Reload values:
# systemctl --system daemon-reload

Restart service:
# service mysql restart
(# service mariadb restart)

You might need to change the MySQL open_files_limit variable, too:
MySQL :: MySQL 5.7 Reference Manual :: 5.1.4 Server Command Options

If this cannot be done you can try to create your MySQL Dump on the CPanel machine by adding
--single-transaction
as a command line parameter. It will break down the transactions to be done one by one.

If that does not help, you can try to user Ozerov's "Bigdump" utility for import.
BigDump: Staggered MySQL Dump Importer