From: Peter Brawley
Date: February 18 2005 5:50pm
Subject: Re: backing up Databases in Mysql
List-Archive: http://lists.mysql.com/mysql/180191
Message-Id: <42162AE2.1010301@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Nestor,

1. LOCK TABLES;
    FLUSH TABLES;
(allow reads, stall writes)
2. Copy the db dir
3. UNLOCK TABLES;
4. cd datadir
    mv mysql.log mysql.old
    mysqladmin flush-logs

PB

Nestor Florez wrote:

>TO back up the databases in Mysql, isn't there a way where you can just copy somefiles
>to another directory and in essence you have a backup?  I thought I read this somewhere
>
>No I can do a dump, but I was wondering if I can just copy some lies or a directory.
>
>Thanks,
>
>Néstor Alberto Flórez Torres
>
>
>
>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/2005