Hi,
To take consistent backup, it is enough if you go for "mysqldump".
1) $ mysqldump -u user -p <dbname> [table1,table2] > <dumpfile with path>
-- this itself takes consistent backup. mysqldump utility by default locks
the table.
2) From one terminal issue
mysql> LOCK TABLES <tables> WRITE;
From another table, issue $>mysqldump -u user -p <dbname> [table1,table2] >
<dumpfile with path>
and unlock the tables once dump completed.
Thanks
ViSolve DB Team
----- Original Message -----
From: "Ananda Kumar" <[EMAIL PROTECTED]>
To: "ViSolve DB Team" <[EMAIL PROTECTED]>
Cc: "MySQL" <mysql@lists.mysql.com>
Sent: Friday, June 15, 2007 4:30 PM
Subject: Re: mysqldump for myisam tables.
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
--------------------------------------------------------------------------------
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]
