+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: Database Errors (/showthread.php?tid=4046)
- BayBay - 10-01-2014
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 - 10-01-2014
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 - 10-01-2014
maybe you must increase mysql values to accept bigger packets.
- fonsy84 - 10-01-2014
sorry for double post , but if remember good , you must go to my.conf and add line into [mysqld] maxpacket_allowed 100M
- peter3301 - 10-01-2014
@fonsy
He increase the value with the command in the first post.
- Wizatek - 10-01-2014
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 - 10-01-2014
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 - 10-01-2014
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 - 10-01-2014
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 - 10-01-2014
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!