Hi
You can also use "mysqlhotcopy".
like
$ mysqlhotcopy <dbname> <destination directory>
the option
--addtodest - does not delete/rename the directory if <destination
directory> exists; instead it will append the data to the same.
[$mysqlhotcopy --addtodest dbname <destination directory>]
--allowold - create a new <destination directory>; if that already exists
renames it to <destination directory>_old. [mysqlhotcopy --allowold
<dbname> <destination directory>]
mysqlhotcopy is only for myisam & archive tables.
While restoring, simply place the dumped directory into to mysql data dir.
You can use either mysqldump or mysqlhotcopy.
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]
