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
Hi Dan,
- Original Message -
From: dan orlic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 2:30 PM
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
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
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
On Thu, Sep 11, 2003 at 04:27:10PM -0400, Brent Baisley wrote:
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.
It