1. LOCK TABLES;
(allow reads, stall writes)
2. Copy the db dir
3. UNLOCK TABLES;
4. cd datadir
mv mysql.log mysql.old
Nestor Florez wrote:
>TO back up the databases in Mysql, isn't there a way where you can just copy
>to another directory and in essence you have a backup? I thought I read this
>No I can do a dump, but I was wondering if I can just copy some lies or a directory.
>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