Live backup of a "static" database

[GalaxiePete]

I can not seem to find a straight forward answer to this question. I am wondering if I can simply tar a MySQL database that I have loaded onto a web server for a backup. The content is static. I don't want to corrupt either the backup or original. I wouldn't be asking if I had a choice...

Thanks

 

[abombss]

If the database is readonly you shouldn't have a problem. But I would highly recommend running the MySQL Hotcopy perl script if you can. It will safely lock the database for you and copy the proper definition, data and index files if you need it.

I have copied, tar'd a live readonly database before no problem.

abombss

 

[twcman]

abombss,
what would the syntax be to hotcopy a database name db1 to location d:\mysql\data\backups? I would need structure and data, please.

Chris Scott
The Whole Computer Medical Systems