I am upgrading otrs on a new System Linux Centos5.0 and I want to import the backup from another old linux Debian with otrs 2.0.4.

…But when I start the script or I import the database_backup.sql on mysql it tells me:

------------------------------------------------------------------------------------------------------

[root@otrs Backup]# /opt/otrs/scripts/restore.pl -b /opt/otrs/Backup/ -d /opt/otrs/

Restore /opt/otrs/Backup//Config.tar.gz ...

Restore /opt/otrs/Backup//Application.tar.gz ...

create MySQL

decompresses SQL-file ...

cat SQL-file into MySQL database

ERROR 1153 (08S01) at line 672: Got a packet bigger than 'max_allowed_packet' bytes

compress SQL-file...

[root@otrs Backup]#

----------------------------------------------------------------------------------------------------------

[root@otrs sql]# mysql --max_allowed_packet=999MB -u root otrs -p <DatabaseBackup.sql

Enter password:

ERROR 1153 (08S01) at line 672: Got a packet bigger than 'max_allowed_packet' bytes

[root@otrs sql]#

----------------------------------------------------------------------------------------------------------

I set the max_allowed_packet=999MB in /etc/my.cnf and restarted mysqld service

Where else should I look?

Thanks

Ciao