hi,
I successfully imported a mysql database dump on my old server(mysql 5.0.18) to my new server(mysql 5.0.22). But when I run the dump command on the new server, I get an error:
input: mysqldump --password='madeuppassword' --opt bugs > /home/bugzilla/dump.sql
output: mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `attach_data` at row: 725
I've tried :
1. run mysqlcheck (no errors)
2. Modify /etc/my.cnf by adding "max_allowed_packet=1024M" under [mysqld]
3. Modifying /etc/my.cnf by adding "ulimit -d 256000" under [mysqld_safe]
but I'm still unable to create a dump file. Do you have any suggestions that may overcome this problem?
Much appreciated,
Tom
I successfully imported a mysql database dump on my old server(mysql 5.0.18) to my new server(mysql 5.0.22). But when I run the dump command on the new server, I get an error:
input: mysqldump --password='madeuppassword' --opt bugs > /home/bugzilla/dump.sql
output: mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `attach_data` at row: 725
I've tried :
1. run mysqlcheck (no errors)
2. Modify /etc/my.cnf by adding "max_allowed_packet=1024M" under [mysqld]
3. Modifying /etc/my.cnf by adding "ulimit -d 256000" under [mysqld_safe]
but I'm still unable to create a dump file. Do you have any suggestions that may overcome this problem?
Much appreciated,
Tom