A fix to mysql backup error dump
A fix to mysql backup error dump
Hi Folks
Just fixed an issue when running a backup, mysql error dump. faild, and backup stops
Command is
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
Just fixed an issue when running a backup, mysql error dump. faild, and backup stops
SSH into server and under rootFIX
Command is
sudo -i
Enter password
Just undernano /etc/mysql/my.cnf
Add this line belowinnodb_file_per_table
Ctrl+O to save & then Ctrl+X to exitopen_files_limit=2048
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
Re: A fix to mysql backup error dump
Thats interesting, never happened to me (yet) lol
Re: A fix to mysql backup error dump
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
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
Re: A fix to mysql backup error dump
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.
You wont believe this, but...
I just had this freaking issue on production on a different way, it was saying:
Code: Select all
[ERROR] /usr/sbin/mysqld: Can't open file: './database/table.frm' (errno: 24)
Great fix, I just did it in about 10 minutes lol.
Thanks man.
Re: A fix to mysql backup error dump
Hi mike08
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
Glad to here it worked for you, hopefully this is something that can be edited in admin section.You should Never say Never ....lol
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