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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
