Re: Point-in-Time (Incremental) Recovery Using the Binary Log

[Gerard Roy Co]

Hi Guys,

Thank you for the reply.

forgot to mention that i'm not setting up replication, it's incremental backup recovery by enabling binlog

inside the my.ini
----------------------------
log-bin="C:binlog/bin-log"
binlog-do-db="dbname1"
expire_logs_days=10
max_binlog_size=10M
binlog-format = MIXED
----------------------------

during full backup using mysqldump i include, --single-transaction and --flush-logs then full backup restored new server. but when tried to restore the binlog by using the mysqlbinlog command then it returns the primary key error. Please help

Thanks