MySQL Forums :: Workbench - Database Administration :: Copy database to a new Server

Hello,

I want to copy a OTRS Database from one MySQL Server to an other Server, but doing this have a problem.

For the export I used the command

mysqldump -u XXXX -p --hex-blob --max_allowed_packet=128M -x -t otrs > otrs_all.sql

And everything works fine. When I want to restore the database on the mew Server via command

mysql -u XXXX -p --max_allowed_packet=128M otrs < otrs_all.sql

I get follwing errro Message:

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

The error occurs in a table with BLOB Cloumn.

Has anyone of you an tipp what I made wrong, or what I schould do to fullfill the copy of the database.

Thanks for your help.

Franz-Josef