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 direc
On Friday 18 February 2005 11:28 am, 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
mysqlhotcopy does this for myisam tables, there is a hot c
