Web Hosting Talk







View Full Version : MySQL Incremental Backup


holy_joy
05-31-2006, 02:32 PM
hello,
I need a software or a source code to daily backup my online MySQL database. I want to use the Incremental method.
Can MySQL administrator do it? How?

sasha
05-31-2006, 03:30 PM
You can set something up to backup and flush binary logs. The summary is that binary logs hold all queries performed in mysql so you can use them to "replay" certain period. But do not take my word for it, check the manual on mysql site.

Accu_John
06-01-2006, 08:33 AM
Hello Holy,

There is a software named as "Swordsky" which used to backup and restore your remote/local MySQL databases automatically.

Hope this will help you.

Best regards,

SmilieBG
06-01-2006, 06:16 PM
yes, I belive sasha is right. It is, I think, similiar to the shadow mysql server. But have no details - sorry :(
Maybe that would be also an option...?

Cheers,
Aleks