• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Resolved Mysql backup error

Anas_Altunji

New Pleskian
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.
 
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 :)
 
Back
Top