inside the mind of a linux admin

MySQL: got a packet bigger than ‘max_allowed_packet’ bytes

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.

Related Posts

synergy: How to enable crypto (encryption) and generate SSL certificate

The newer Linux versions of the popular mouse/keyboard sharing application “synergy” now has built in encryption. Here’s how to configure it: Just simply passing the –enable-crypto flag on your synergy server without having a proper SSL certificate will result in the inability to connect to clients and generate an error message similar to this in […]

Read More

Change Number Pad Delete (dot) key from a comma in Ubuntu Linux

I recently purchased a new keyboard and updated to the latest Ubuntu, I’m also an avid user of the number pad for quick input when dealing with spreadsheets or accounting. I found that my num pad’s delete key (“.”) was outputting a comma (“,”) instead. Pretty annoying? I agree, but this can be very easily […]

Read More

8 Comments

  • Waylon Kollman on Thursday, February 18, 2010

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

  • internet banking legal issues on Thursday, April 1, 2010

    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.

  • Bank online with Wachovia on Thursday, April 1, 2010

    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.

  • facebook poker on Saturday, April 3, 2010

    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

  • Unblock Myspace on Monday, April 5, 2010

    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.

  • new moon on Wednesday, April 7, 2010

    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 🙂

  • Proxy on Thursday, April 8, 2010

    @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.

  • hospedagem de sites on Thursday, April 8, 2010

    Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.