MySQL Forums
Forum List  »  Data Recovery

mysqldump can not be restored
Posted by: Franz-Josef Tophoven
Date: November 27, 2010 03:31PM


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


Options: ReplyQuote

Written By
mysqldump can not be restored
November 27, 2010 03:31PM
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.