Fix table locking problem when mysqldump database with too many connections error
Example of mysqldump command:
mysqldump -u root -p'password' database > /home/backup.sql
So to fix this problem you need to access the mysql server configuration file "my.cnf" located in "/etc" using ssh vi command or ftp, then add the bellow codes then save it:
# THIS TO STOP TABLE LOCKING WHEN BACKUP DB USING MYSQLDUMP :
Now restart your mysql server (using "service mysqld restart").
That's it now try to run your mysqldump and see the result, you'll notice a fast backup with no locking errors.
If you like this article, please share it on facebook, tweet it and +1 it to spread it :) !
Fix table locking problem when mysqldump database with too many connections error Reviewed by Maherr Live on Thursday, April 16, 2015 Rating: