If your tables are InnoDB, you could look at InnoDB HotBackup: http://www.innodb.com/hotbackup.html
Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: SAQIB [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2003 11:45 AM > To: [EMAIL PROTECTED] > Subject: Best Pratices for mySQL Backups in Enterprise > > > 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/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
