On 7/4/06, Danil V. Gerun <[EMAIL PROTECTED]> wrote:
> that is like 'mirroring' right? errmm..maybe i'll try it someday. > right now can anybody share with me on differential/incremental backup? What database do you use? If MySQL, then check out the binary logs feature somewhere in manual for MySQL. You can define a single database to keep binary logs for, or the whole server. Or exclude particular database(s). Well, I think I shouldn't retell the docs here, they are rather clear. The backup strategy is described here, for example: http://downloads.mysql.com/docs/refman-4.1-en.chm In Database Administration - Backup and Recovery The idea is simple (like newsyslog) - you set up binary logging, schedually do FLUSH LOGS (it rotates the binary log) and backup the fresh binary log. Every 7 times you can make a full backup and delete the logs. That's the problem I came accross some says ago, when camcontrol in FreeBSD started to show growing amount of defects on hard drive ;-) -- Best regards, Danil V. Gerun.
Check out http://www.nongnu.org/rdiff-backup/ -- Demi