Database Errors

[BayBay]

I was thinking of saving all my dbs so i decided to start dumping all my db's when i try re-executing them in a new database this happened look:

 

Dumping newproject_data:

 

 
 
After Executing newproject_data in "newproject_dataCOPY:
 

 
 
 
When i scrolled up i found this : [Err] 1153 - Got a packet bigger than 'max_allowed_packet' bytes
 
I also applied this to my server when i followed the "how to setup your server quickly" set global max_allowed_packet=100000000;   idk if that is whats affecting me now.  IF so then how do i change the max allowed packet?

 
 
 

[peter3301]

Use a higher value or insert the .sql with an little command, but First you need to upload the sql.(example)

 

mysql -u root newproject_data < newproject_data

[fonsy84]

maybe you must  increase mysql values to accept bigger packets.

[fonsy84]

sorry for double post , but if remember good , you must go to my.conf and add line into [mysqld] maxpacket_allowed 100M

[peter3301]

@fonsy

He increase the value with the command in the first post.

[Wizatek]

The right answer comes from Peter. 

 

Not only is it the fastest method, applying such tables from a windows machine might mess up the capitals in names, t_magicLevel => t_magiclevel 

 

for backing up : mysqldump

for restoring : mysql

 

those are the only programs you need for this and are already installed on your server

[BayBay]

The right answer comes from Peter. 

 

Not only is it the fastest method, applying such tables from a windows machine might mess up the capitals in names, t_magicLevel => t_magiclevel 

 

for backing up : mysqldump

for restoring : mysql

 

those are the only programs you need for this and are already installed on your server

Exactly what command do i use to increase the value since i assumed my max allowed packets were 100M but executing a file of 36.5MB fails?I forgot to mention i connect to my vmware mysql via windows side on navicat...

[BayBay]

Use a higher value or insert the .sql with an little command, but First you need to upload the sql.(example)

mysql -u root newproject_data < newproject_data

I already tried increasing the number of max allowed packets via terminal but for some reason its not working. SAYS Ok, but 0 ROWS affected 0.0seconds. And uploading db isnt that the same thing as if i executed in navicat from my Windows machine?

[CDWriter]

when adding tables to your mysql if you have error like 

 

MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes

 

do the following to fix it

 

On CENTOS 6 

"vi /etc/my.cnf" , under [mysqld] section the correct syntax is:

 

[mysqld]

# added to avoid err "Got a packet bigger than 'max_allowed_packet' bytes"

#

net_buffer_length=1000000 

max_allowed_packet=1000000000

#

 

 

then save restart mysql 

[BayBay]

 

when adding tables to your mysql if you have error like 
 
MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes
 
do the following to fix it
 
On CENTOS 6 
"vi /etc/my.cnf" , under [mysqld] section the correct syntax is:
 
[mysqld]
# added to avoid err "Got a packet bigger than 'max_allowed_packet' bytes"
#
net_buffer_length=1000000 
max_allowed_packet=1000000000
#
 
 
then save restart mysql 
 

Thank you soo much CDWriter ill try that right away and ill see what happens.

 

Thanks ALOT CDWriter that totally solved my problem!