Mysql restore packet bigger than 'max_allowed_packet'

[Geethu03]

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.

[ronverdonk]

Can you increase the max_allowed_packet size yourself?

Ronald :cool:

[Motoma]

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.

[Geethu03]

Can you increase the max_allowed_packet size yourself?

Ronald :cool:

How can i increase the max_allowed_packet?

[Motoma]

How can i increase the max_allowed_packet?

Read my previous response.