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
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 Tor
