Came across this rather annoying error when importing a rather large database into mySQL.

Here’s an easy fix:

Open mySQL console as root:

mysql> set global max_allowed_packet=1000000000;
mysql> set global net_buffer_length=1000000;

Then import your database:

# mysql db_name < sqldump.sql

Done.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

  1. I enjoy reading your blog and intend to continue visiting it daily.

  2. Glad to see that this site works well on my iPhone , everything I want to do is functional. Thanks for keeping it up to date with the latest.

  3. Just killing some in between class time on Stumbleupon and I found your post . Not typically what I like to learn about, but it was definitely worth my time. Thanks.

  4. eventhough I burn the majority of of my daytime hours on the internet trying to play video games like myspace poker or restaurant city, I still like to dedicate some spare time to visit a number of information sites on occasion and I am pleased to report this latest information is in truth more or less good and quite superior than 50 % the various other junk I read today , at any rate i’m off to have fun with a few rounds of zynga poker

  5. Hey, I just hopped over to your site via StumbleUpon. Not somthing I would normally read, but I liked your thoughts none the less. Thanks for making something worth reading.

  6. new moon says:

    hello really good little blogging site you have right here :-) I employ the very same web theme on my website however for whatever reason why it looks to stream more efficiently on this website although yours includes a lot more content material. Have you been utilizing any individual plugins or widgets which speed it up? If you could quite possibly share the plug ins so I could use these in my own blog so twilight breaking dawn followers could watch twilight eclipse online trailers and videos more quickly I would be grateful – kudos in advance :)

  7. Proxy says:

    @chels I know what you mean, its hard to find good help these days. People now days just don’t have the work ethic they used to have. I mean consider whoever wrote this post, they must have been working hard to write that good and it took a good bit of their time I am sure. I work with people who couldn’t write like this if they tried, and getting them to try is hard enough as it is.