Error
  • Request Forbidden
  • Request Forbidden
 Linux Training Community :: CentOS
Board Index Latest Posts Welcome Guest   
 Subject :Centos and Mysql.. 2009-10-24 00:09:54 
jimjam
Joined: 2009-09-26 23:15:15
Posts: 24
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
 Subject :Re:Centos and Mysql.. 2009-10-28 04:17:37 
MikeW
Rookery Moderator
Joined: 2009-06-03 13:47:46
Posts: 66
Location: 
You may have to increase the size even more. Where did you change the setting? Do you have PHP working with your MySQL and have you adjusted the PHP as well?
IP Logged
Page # 


Powered by ccBoard