i guess the requirement is "daily snapshots". "incremental backups" are to ease on storage space requirement.
however incremental backups still need the base backup right? and depend on some other incremental backups back the time line. and how easy is it to recover that? why not just do daily whole database or table snapshots? then compress them. then take the second mile by cron'ingly and passwordlessly (ssh) copying them to at least another host. On Mon, 23 Aug 2004 12:27:28 +0800, Miguel A Paraz <[EMAIL PROTECTED]> wrote: > Hi, > I'm trying to address the requirement of MySQL incremental dumping for > backup. From what's on the web, it looks like it's not inherently > supported by MySQL, but is done by commercial software. > > Is it practical to get a 'diff' between mysqldump output from > day-to-day, and back that up for an incremental backup? > > Note: this isn't my own system so changing database engines is not an option. > > Thank! -- Seek ye first the kingdom of God and all these things shall be added unto you. -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
