MySQL Forums
Forum List  »  Data Recovery

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

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

Options: ReplyQuote


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