Re: mysql dump speed

[Brent Baisley]

Have tried using the --opt parameter on mysqldump? This is supposed 
optimize the dump speed and create a file optimized for reloading. I 
haven't played with this option, so I don't know what kind of 
difference it makes.

On Thursday, September 11, 2003, at 03:30 PM, dan orlic wrote:

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

--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]