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. Link to comment https://forums.phpfreaks.com/topic/101413-cant-restore-database-max_allowed_packets/ Share on other sites More sharing options...
fenway Posted April 16, 2008 Share Posted April 16, 2008 What do you mean by restore? Link to comment https://forums.phpfreaks.com/topic/101413-cant-restore-database-max_allowed_packets/#findComment-518706 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. Link to comment https://forums.phpfreaks.com/topic/101413-cant-restore-database-max_allowed_packets/#findComment-518715 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). Link to comment https://forums.phpfreaks.com/topic/101413-cant-restore-database-max_allowed_packets/#findComment-518717 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? Link to comment https://forums.phpfreaks.com/topic/101413-cant-restore-database-max_allowed_packets/#findComment-518743 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. Link to comment https://forums.phpfreaks.com/topic/101413-cant-restore-database-max_allowed_packets/#findComment-519722 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? Link to comment https://forums.phpfreaks.com/topic/101413-cant-restore-database-max_allowed_packets/#findComment-519749 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. Link to comment https://forums.phpfreaks.com/topic/101413-cant-restore-database-max_allowed_packets/#findComment-519750 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? Link to comment https://forums.phpfreaks.com/topic/101413-cant-restore-database-max_allowed_packets/#findComment-519755 Share on other sites More sharing options...
Imad Posted April 17, 2008 Author Share Posted April 17, 2008 Below the password value. Link to comment https://forums.phpfreaks.com/topic/101413-cant-restore-database-max_allowed_packets/#findComment-519795 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.