473,246 Members | 1,349 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,246 software developers and data experts.

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 9889
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

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

Similar topics

0
by: I.P. | last post by:
Hi, it's my story. I have two 4.0.14 mysql server on one machine with win XP Professional polish version. First acts as master: on port 3300 Second acts as slave: on port 3301 below my...
0
by: I.P. | last post by:
No one has replied to my post. ----- Original Message ----- From: "I.P." <jancio_wodnik@wp.pl> To: <mysql@lists.mysql.com> Sent: Monday, August 18, 2003 1:01 PM Subject: mysql 4.0.14 +...
4
by: Christian Tonke | last post by:
Hallo, ich habe folgendes Problem: Ich möchte große Dateien in meiner MySQL Datenbank abspeichern. Ich erhalte immer wieder die Meldung " ..packet bigger than max_allowed_packet " wenn ich die...
0
by: Plymouth Acclaim | last post by:
Hi guys, We have a problem with Dual AMD64 Opteron/MySQL 4.0.18/Mandrake 10 for a very high volume site. We are evaluating the performance on our new server AMD64 and it seems it's slow compared...
1
by: Alban Gerome | last post by:
Hi there, I'm trying to export a pictures table, my mySQL database table already exists so I have linked both tables in Access and I tried to run a simple append query in Access to export the...
1
by: jlee | last post by:
I'm pretty much a newbie on mysql, and I need some help. I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4 (i386) on a server hosting an active website. The site's developer...
1
by: Good Man | last post by:
Hi there I've noticed some very weird things happening with my current MySQL setup on my XP Laptop, a development machine. For a while, I have been trying to get the MySQL cache to work....
1
pradeepjain
by: pradeepjain | last post by:
hai guys i am facing a small problem... i am trying to upload a file of size 4mb .....but i am getting this error "Got a packet bigger than 'max_allowed_packet' bytes" how to solve this ...
6
by: Keith Hughitt | last post by:
Hi all, I've run into a strange error while trying to store some PNG images in a MySQL database using MySQLdb. When I try to insert smaller images (< 64kb or so) everything seems to work fine....
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.