In article <469C2989.2050902@xaprb.com> baron@xaprb.com
(BaronSchwartz) wrote:

> B. Keith Murphy wrote:

>> The problem is that I am realizing that this dump/import is going
>> to take hours and in some cases days. I am looking for any way to
>> speed this up. Any suggestions?

> The fastest way I've found is to do SELECT INTO OUTFILE on the
> master, which selects into a sort of tab-delimited format by default
> -- don't specify any options like field terminators or whatnot. This
¾*file can then be imported directly into LOAD DATA INFILE, again
> without options.
*

You may also see a speed increase by adding the indexes after the data
is inserted.

***
Andrew Hutchings - LinuxJedi - http://www.linuxjedi.co.uk/
Windows is the path to the darkside...Windows leads to Blue Screen. Blue Screen leads to downtime. Downtime leads to suffering...I sense much Windows in you...