"Matsunobu, Yoshinori" <[EMAIL PROTECTED]> wrote: > I'd like to ask about backup/restore(roll forward recovery) solutions > using mysqldump and binary logs. > > ^[$B!&^[(JVersion : 4.0.20 > ^[$B!&^[(JUsing 1 database.(ex. sample1db) > ^[$B!&^[(JAll 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 > ------------- >
Use --master-data option of mysqldump. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]