Knowledgebase
MySQLdump backup script not working in 5.5
Posted by noobadmin, 09-08-2012, 02:41 PM | I recently upgraded my MYSQL server to 5.5.25 and now the backup script that I had, isn't working and producing this error
Here is the script that I am using
I am guessing this isn't a problem with the backup script, but rather MYSQL dump. If yes, then how do i fix it?
|
Posted by George_Fusioned, 09-08-2012, 02:45 PM | Can you post your /etc/my.cnf please?
|
Posted by noobadmin, 09-08-2012, 02:50 PM | Here it is
Oh yes, I am not using any innodb tables.
Last edited by noobadmin; 09-08-2012 at 02:51 PM.
Reason: added
|
Posted by dareORdie, 09-08-2012, 02:53 PM | Add the following lines to /etc/my.cnf
|
Posted by rustelekom, 09-08-2012, 02:54 PM | Hi,
Perhaps you just need remove innodb_file_per_table=1 from your /etc/my.cnf file. MysQL 5.5 use new naming for innodb.
|
Posted by noobadmin, 09-08-2012, 08:54 PM | Thanks, changed the mysqldump parameters to the one I was using earlier i.e. quick max_allowed_packet = 128M and it worked. Not sure who put those extra parameters in, but I guess that was the primary issue.
|
|
Add to Favourites
Print this Article |
Also Read
websytz.com (Views: 603)