MySQL backups

[Thomas Charron]

On 10/15/07, Ben Scott <dragonhawk at gmail.com> wrote:
> On 10/15/07, Thomas Charron <twaffle at gmail.com> wrote:
>   Open file agents do *nothing* to address problems due to files on
> disk being in an inconsistent state when the backup runs.  With MS
> Excel or whatever, this isn't an issue.  Not so with a database.

  I didn't clarify.  These backups are taking place on a Windows 2003
Server running under VMWare.  My appologies for not clarifying.  I was
more curiouse as to if binary backup of the file done while it was
locked would be bad, which I believed it was, do to past experience.

> > But they insist it HAS to be done without taking any services available on
> > the system down.  Specifically, for CVS, this CANNOT be done.
>   Well, for MySQL, just do database-to-disk dumps and back those files
> up, like I said.

  Yes, but if they hose my server while doing their backups I'm going
to be pissed.

>   I don't really know much about CVS from an admin POV, so I can't
> comment there.  Is there a way to make a transactional copy of an
> entire CVS repository?

  CVS locks per file, which means that the file changes are atomic per
file.  Checkin in the middle of the backup, and the restore has half
your checked in files, with no record of the rest.  Aka, fudged up.

  I can copy the CVS repositories as well, but my concern is them
affecting the operation of my machine.

-- 
-- Thomas