Restoring Large MySQL Dumps

| No Comments | No TrackBacks

I'm not exactly sure what the problem is here, but when restoring some dumps I have problems which results in the message the server has gone away. This fixes it, log in to another mysql session and enter this:

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

It will magically now work!  

No TrackBacks

TrackBack URL: http://mt.pu-gh.com/mt-tb.cgi/13

Leave a comment

About this Entry

This page contains a single entry by rod published on May 11, 2011 4:07 PM.

Parallel Processing with PHP was the previous entry in this blog.

Getting Clojure is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Categories

Pages

OpenID accepted here Learn more about OpenID
Powered by Movable Type 4.21-en