Vesta Control Panel - Forum

Hi Folks

Just fixed an issue when running a backup, mysql error dump. faild, and backup stops

FIX

SSH into server and under root
Command is

sudo -i
Enter password

nano /etc/mysql/my.cnf

Just under

innodb_file_per_table

Add this line below

open_files_limit=2048

Ctrl+O to save & then Ctrl+X to exit

Restart mysql in the admin section

and then run your back up

P.S make sure you do this for all of your servers.!
Cheers
Govo

Thats interesting, never happened to me (yet) lol

Hi Mike

It happens when there is locked tables, gives all sorts of errors when you run the mysql manually.
For now it has resolved my issue, and I just posted it here encase some else comes into the same problem.


Thanks for the reply

Cheers
Govo

Govo,

You wont believe this, but...

I just had this freaking issue on production on a different way, it was saying: I just found out that there might be lot of processes running by the service and by increasing the files per table to at least 2048 it properly worked, I think that this number could be put on a higher level in case we have too many sites with a lot of info on the db.

Great fix, I just did it in about 10 minutes lol.
Thanks man.

Hi mike08

You should Never say Never ....lol

Glad to here it worked for you, hopefully this is something that can be edited in admin section.

The idea behind it that would that the file would be create by php and saved to /etc/mysql/my.cnf, with the data been pulled from a database allowing you to change the value, I will look at creating this file at some stage later today, as logging in and out of ssh can be a pain, I just need to find the path to the main admin folder to able to include the file into the admin section.

Again great hear it fixed it for you.

Cheers
Govo