Linux Training Community
Welcome Guest   [Register]  [Login]
 Subject :Centos and Mysql.. 2009-10-24 00:09:54 
jimjam
Joined: 2009-09-26 23:15:15
Posts: 14
Location
Hi all,

I am trying to import a large database sql dump, but I am getting the error.

error 1153 (08s01) at line 15442: got a packet bigger than 'max_allowed_packet' bytes

I have been told that the fix is simple and that i just need to restart mysql like so

mysqld --max_allowed_packet=32M

Except that when I run this I get the following error


[rootATlocalhost ~]# mysqld --max_allowed_packet=32M
-bash: mysqld: command not found
[rootATlocalhost ~]#


Can anyone tell me why mysqld is not working, is it stored somewhere else in Centos?

Hope you can help Thanks
IP Logged
Page # 


Powered by ccBoard