Thanks to all for this reply.
regards
anandkl
On 6/17/07, Geoffroy Cogniaux <[EMAIL PROTECTED]> wrote:
2007/6/16, ViSolve DB Team <[EMAIL PROTECTED]>:
> -- this itself takes consistent backup. mysqldump utility by default
locks
> the table.
yes with --lock-tables option which do a "FLUSH TABL
2007/6/16, ViSolve DB Team <[EMAIL PROTECTED]>:
-- this itself takes consistent backup. mysqldump utility by default locks
the table.
yes with --lock-tables option which do a "FLUSH TABLES WITH READ LOCK"
and is a good consistent way for myisam tables.
--
MySQL General Mailing List
For list arc
eam
- Original Message -
From: "Ananda Kumar" <[EMAIL PROTECTED]>
To: "MySQL"
Sent: Friday, June 15, 2007 10:05 AM
Subject: Re: mysqldump for myisam tables.
> Hi All,
> What are the parameters that i need to use to take consistent backup of
> myisam tables
ECTED]>
To: "MySQL"
Sent: Friday, June 15, 2007 10:05 AM
Subject: Re: mysqldump for myisam tables.
> Hi All,
> What are the parameters that i need to use to take consistent backup of
> myisam tables using MYSQLDUMP.
>
> regards
> anandkl
>
>
> On 6/15
mar" <[EMAIL PROTECTED]>
To: "MySQL"
Sent: Friday, June 15, 2007 10:05 AM
Subject: Re: mysqldump for myisam tables.
Hi All,
What are the parameters that i need to use to take consistent backup of
myisam tables using MYSQLDUMP.
regards
anandkl
On 6/15/07, Ananda Kumar <[
he server before starting the
dump and unlocks the same.
--opt is default.
Thanks
ViSolve DB Team
- Original Message -
From: "Ananda Kumar" <[EMAIL PROTECTED]>
To: "MySQL"
Sent: Friday, June 15, 2007 10:05 AM
Subject: Re: mysqldump for myisam tables.
Hi All,
Hi All,
What are the parameters that i need to use to take consistent backup of
myisam tables using MYSQLDUMP.
regards
anandkl
On 6/15/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi All,
I am taking mysqldump of myisam table for the first time on a production
database. Can you please let me k
Hi All,
I am taking mysqldump of myisam table for the first time on a production
database. Can you please let me know what all necessary thing i need to take
care before i start mysqldump. Its on a running database. Also please tell
me what all important parameters i need to use in mysqldump.
Th