Imad Posted April 16, 2008 Share Posted April 16, 2008 Hi guys, I need help with the max_allowed_packets. I opened up my.cnf to change the max_allowed_packets value. However, their isn't any line in that file that has max_allowed_packets and mysql won't let me restore my 500MB database. Any Ideas? Thanks. Quote Link to comment Share on other sites More sharing options...
fenway Posted April 16, 2008 Share Posted April 16, 2008 What do you mean by restore? Quote Link to comment Share on other sites More sharing options...
Imad Posted April 16, 2008 Author Share Posted April 16, 2008 I built a new server and need to upload my database into mysql. So I get the max_allowed_packets error. Regards. Quote Link to comment Share on other sites More sharing options...
mwasif Posted April 16, 2008 Share Posted April 16, 2008 It is max_allowed_packet (I don't know if there is max_allowed_packets). Quote Link to comment Share on other sites More sharing options...
fenway Posted April 16, 2008 Share Posted April 16, 2008 You should be able to simply add this line to the my.cnf file... but I'm not sure why you're having this issue. Do you have very long multi-valued insert statements? or huge blobs? Quote Link to comment Share on other sites More sharing options...
Imad Posted April 17, 2008 Author Share Posted April 17, 2008 I added the max_allowed_packet and gave it an extremely high value and I still get an error telling me I exceeded the bytes limit. ??? The database is for my forums. Any other ideas? Best Regards. Quote Link to comment Share on other sites More sharing options...
mwasif Posted April 17, 2008 Share Posted April 17, 2008 I added the max_allowed_packet and gave it an extremely high value and I still get an error Did you restart MySQL? How you are importing database? Quote Link to comment Share on other sites More sharing options...
Imad Posted April 17, 2008 Author Share Posted April 17, 2008 I did restart MySQL I'm importing it using the Linux Shell. Quote Link to comment Share on other sites More sharing options...
mwasif Posted April 17, 2008 Share Posted April 17, 2008 In which section you added this value in my.cnf? Quote Link to comment Share on other sites More sharing options...
Imad Posted April 17, 2008 Author Share Posted April 17, 2008 Below the password value. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.