SAQIB wrote:
We are in the process of implementing enterprise wide (20,000+ users) application that will use mySQL as the Database engine. I was wondering if the slashdot readers can provide me some details about best practices / experiences for Backing Up and Restoring mySQL Databases. I am planning to setup a cron job, to lock the tables, use msqlhotcopy and then unlock the tables. Is that a good backup strategy? Is there a ready-made perl script that I can use? Is there a commercial solution for Backups? What other things do I need to keep in mind? What do other people do in production use, where the DB is frequently?
I have already read "mySQL: The definitive guide to to using, programming and administring mySQL 4", but did not find ay good information about backing up and restoring, in the 24x7 operation for Data Center use.
Any ideas will highly appreciated.
Thanks Saqib Ali
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
