HI
You can use
$mysqldump dbname table1 [,table2,table3] >dumpfile[path] or $ mysqldump
dbname > dumpfile [path]
or
$ mysqldump --all-databases >dumpfile [path]
--opt will Add a DROP TABLE statement before each CREATE TABLE, Uses the
multiline INSERT syntax,Locks all tables on the 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" <mysql@lists.mysql.com>
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 <[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 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.
Thanks for your help
regards
anandkl
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.16/849 - Release Date: 6/14/2007
12:44 PM
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
