mysqldump can not be restored
Hello,
I have a big problem with a Database in a MYSQL Server.
When I backup the database with the command:
mysqldump -u tophoven -p --hex-blob --max_allowed_packet=128M -x -t otrs > otrs_all.sql
everything works fine. But when I try to restore the database via the command
mysql -u tophoven -p --max_allowed_packet=128M otrs < otrs_all.sql
I get following error:
ERROR 1153 (08S01) at line 87: Got a packet bigger than 'max_allowed_packet' bytes
The error occorce even if I set the parameter --max_allowed_packet to 1G.
Can anyone help me, or does any one of you have a tip for mne.
Thanks for your help
Franz-Josef
Subject
Views
Written By
Posted
mysqldump can not be restored
4716
November 27, 2010 03:31PM
1840
November 30, 2010 01:07AM
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.