var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
Mysql 'max_allowed_packet' error
in phpMyadmin when trying to import a database from a file, i'm getting the error:
#1153 - Got a packet bigger than 'max_allowed_packet' bytes
The file I'm importing is only 7.08MB
I have tried setting the packet size in the shell as follows:
mysql> mysqld --max_allowed_packet=32M
I got no error or no confirmation either using this command, sorry I dont use shell commands much so I dont know if thats a problem or if it worked.
anyone any ideas?
Oh and i restarted the MySQL server from WHM after typing that command before trying again
Change the setting in /etc/my.cnf
►► Professional &
Shared, Reseller Services.
Performance, Reliability, Stability.
Your data is safe with us.
»» 99.9 Uptime | Extremely Secure | 24/7 Support | LiteSpeed
★ Hosting anyone can afford. ★
UK AND USA SERVERS
edit your my.cnf or my.ini
change 16M to value that suitable your need.
By Linkdatacenter in forum Programming Discussion
Last Post: 05-25-2008, 04:16 AM
By vnsg in forum Hosting Security and Technology
Last Post: 09-16-2007, 03:09 AM
By TJ111 in forum Programming Discussion
Last Post: 07-09-2007, 04:52 PM
By MrAdmin in forum Dedicated Server
Last Post: 07-04-2005, 05:13 AM
By H_Admin in forum Hosting Security and Technology
Last Post: 03-27-2005, 03:57 PM