You can currently do this with InnoDB with mysqldump (look at the --single-transaction switch). I use it for backing up a 12 GB mail database without problems.
Regards,
Chris
P.S. Keep up the great work over there at Novell! Tell us where to send the expensive bottles of alcohol for when you help put SCO out of their misery!
P Srinivasulu wrote:
Hi All,
The link below says that online backup functionality will be provided in Mysql-5.1. I think its already there in the form of mysqlhotcopy. Is Mysql going to extend the functionality of mysqlhotcopy so that it works for Innodb tables also? or they are going to provide independent online backup functionality. Please clarify me.
http://www.mysql.com/doc/en/TODO_MySQL_5.1.html
Thanks, Srinivasulu.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
