Um its better to use the SQL backup table if the table is a myISAM
table.
BACKUP TABLE [tables] to [LOC].
Or a more sophisticated approach
FLUSH TABLE WITH READ LOCK;
Fork out copy myISAM datafile out
UNLOCK TABLES;
If it's innodb then use the innodb backup script offered by Heikki.
-----Original Message-----
From: Elim Qiu [mailto:elim@stripped]
Sent: Monday, December 06, 2004 9:44 AM
To: mysql@stripped
Subject: wanted: back up script
This is on windows 2000.
I did the following as a temp solution for the full back up of a
database. I know this is not safe and possibly not complete. Any
suggestions (how to lock/unlock a db for read here)?
Thanks
#include <stdio.h>
#include <stdlib.h>
int main() {
printf("start backup ESite data\n");
system("tar cf ESite_dt.tar F:/DBData/MySQLdata/ESite"); system("gzip
ESite_dt.tar"); system("mv ESite_dt.tar.gz ESite_dt.tgz");
printf("done\n"); return 1; }
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.6 - Release Date: 12/5/2004
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
