470,641 Members | 2,555 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,641 developers. It's quick & easy.

Mysql restore packet bigger than 'max_allowed_packet'

Hi
My Question is how can i store the database from one System to another System?

I have a database with large no of data's.I want to store these data to another system with all data.

I can try this with the query mydqldump and restore Queries but it will store some tables and and gives the Error. The Error will occur at the time of Restore

Error is
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -uroot -pindex epc < backup.sql
ERROR 1153 (08S01) at line 376: Got a packet bigger than 'max_allowed_packet' bytes

how can i solve this and to store all data in my database

Anyone help to solve this problem
Thanks in Advance
Geethu.
Apr 2 '07 #1
4 9765
ronverdonk
4,258 Expert 4TB
Can you increase the max_allowed_packet size yourself?

Ronald :cool:
Apr 2 '07 #2
Motoma
3,237 Expert 2GB
Hi
My Question is how can i store the database from one System to another System?

I have a database with large no of data's.I want to store these data to another system with all data.

I can try this with the query mydqldump and restore Queries but it will store some tables and and gives the Error. The Error will occur at the time of Restore

Error is
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -uroot -pindex epc < backup.sql
ERROR 1153 (08S01) at line 376: Got a packet bigger than 'max_allowed_packet' bytes

how can i solve this and to store all data in my database

Anyone help to solve this problem
Thanks in Advance
Geethu.
You will need to break your dump up into smaller segments, or increase your max_allowed_packet size. You can check this value using mysqladmin, but you will need to change the value in my.cnf if you are using it, or in the start up script if you are not.
Apr 2 '07 #3
Can you increase the max_allowed_packet size yourself?

Ronald :cool:
How can i increase the max_allowed_packet?
Apr 3 '07 #4
Motoma
3,237 Expert 2GB
How can i increase the max_allowed_packet?
Read my previous response.
Apr 3 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Christian Tonke | last post: by
???
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.