Re: rsnapshot and compressed db dumps.

On Wed, Aug 09, 2006 at 03:53:06PM -0700, Malcolm Frazier wrote:

> I am wondering how rsnapshot works with compressed MySQL dumped files. 
> So I say I dump a database using mysqldump and gzip it up how will 
> rsnapshot rotate that?

It'll be treated exactly the same as any other file - that is, if
today's file is the same as yesterday's, then a hard link will be
created so it doesn't take up any extra space on your backup server, and
if the file differs it will be copied as a new file and so *will* take
up space.  Of course, things like SQL comments in the dump file and even
a different modification time count as being a change as far as rsync is
concerned, so if MySQL puts the dump date/time in a comment you'll need
to strip that out, and use touch(1) to fiddle the timestamp on the file.

There are some useful scripts for handling databases in the utils
directory.

-- 
David Cantrell | Benevolent Dictator Of The World

          All praise the Sun God
          For He is a Fun God
          Ra Ra Ra!

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642