Use the --opt option when performing the dump. It can make a tremendous difference.
-JF > -----Original Message----- > From: dan orlic [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 12:31 PM > To: [EMAIL PROTECTED] > Subject: mysql dump speed > > > I have a bit of an issue with mysqldumps and inserting it back into > mysql. > > Granted, I have 1 table that has over 1Million entries, but generating > these tables takes about 3 hours with a java app. > But when I do a mysql -u root -p < <the mysql dump.dmp> it is taking > about 28 hours to complete the load. > > Can anyone tell me what is taking so long? Any thoughts as > how to speed > it up? Thanks in advance. > > > Dan orlic > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
