Thanks all for this response. This mysqlhotcopy take backup of .frm,.myd and .myi files, but my boss wants what mysqldump does.
So, is it possible to take a consistent backup of myisam tables using mysqldump. Regards anandkl On 6/15/07, ViSolve DB Team <[EMAIL PROTECTED]> wrote:
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
