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 m
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
>
>
>
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 bi
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.
>
> Gra
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 < it is taking
about 28 hours to complete the load.
Can anyone te
