In article <[EMAIL PROTECTED]> [EMAIL PROTECTED] (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... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]