Backup of files and MySQL db

[poster123]

I have a website running on VPS with Linux and MySQL. How can I create incremental backups? Preferably for both files and MySQL database. Can I have a backup created every x minutes and then have it FTP'ed to another server? How can I make sure that the backup is incremental?

Even if you could point me in the right direction, I would really appreciate it.

Right now I just have a full backup dumped to another server via FTP at set intervals.

Also, what about restoring the site from that incremental backup?

Thank you in advance for your help

[Xasir]

Hello,

There two ways you can perform thr incremental backup in MySql. First way is easy but the other one its little complex

1. Setup the MySql Replication for the incremental update.
2. The second thing is that enable binlogs in mysql it will create a file in which every query stores accept select. Write a simple script to fetch data from that file.

Regards,
Yasir