Hello.
I'd like to ask about backup/restore(roll forward recovery) solutions
using mysqldump and binary logs.
・Version : 4.0.20
・Using 1 database.(ex. sample1db)
・All tables are InnoDB.
I'm considering the following solution.
-------------
backup:
mysqldump --flush-logs --single-transaction sampledb1 > dump1.dmp
(ex. binary logs are generated
hostname.001 (binary log before mysqldump)
hostname.002 (binary log after mysqldump)
)
roll forward:
mysqlbinlog hostname.002 >> dump1.dmp
mysql sampledb1 < dump1.dmp
-------------
Is that OK? Is there any risk of data duplication or lost?
If mysqldump has an interval(a few milliseconds) between
starting dump transaction and switching binary log ,
I think it is possible that data duplication or lost between
dump file and the binary log after mysqldump.
Best Regards,
-------------------------------
Yoshinori Matsunobu
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
