Copy database to a new Server
Date: November 28, 2010 05:15AM
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.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.