Quote:
Originally Posted by 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.
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.
