Resolved Mysql backup error

[Anas_Altunji]

Hi

I have this error when make full server backup Plesk Onyx based on Ubuntu 16.04

Not all the data was backed up into /var/lib/psa/dumps/resellers/XXXX/XXXX mysqldump: Got error: 23: Out of resources when opening file './XXXXXXX/xxxxxxx.MYD' (Errcode: 24 - Too many open files) when using LOCK TABLES.

 

[Bitpalast]

https://talk.plesk.com/threads/comp...n-auto-backuping-database.340852/#post-815436

 

[Anas_Altunji]

Dear Peter

I first changed /etc/security/limits.conf as above.
then add
LimitNOFILE=infinity
To
/lib/systemd/system/mysql.service
and restart mysql server.

Now it's working

Thanks