Checkpointing and backup

[Chris Smith]

Hi,

I'm about to build a fairly hefty e-commerce system for someone with a MySQL 4.1 backend (on Debian Linux). Tables are all on the InnoDB storage engine.

One of the key requirements is that I need to be able to roll back the database to any point in time in 15 minute intervals in the last 12 hours.

Is this possible in MySQL, if so how do I go about it?

I have done it with transaction log backups on SQL Server before but don't know how to approach it with MySQL. I've been using MySQL for the last 3 years and have only done the usual nightly mysqldump.

Any help appreciated.

Cheers,

- Chris.