Christopher McCrory had a post on database backup to this list back on Jan. 23 that I saved. Here is the part about mysql:
> With mysql I run 'mysqlhotbackup'. This is a script that comes with > mysql that locks the DB tables readonly, then copies the db files > somewhere else. Like > /var/mysql/database/whatever.frm -> /backup/mysql/database/whatever.frm. > it uses cp or scp by default, but It was easy to hack it to use rsync. Good luck, Frank --On Thursday, April 04, 2002 10:36:54 -0700 John Rosendahl <[EMAIL PROTECTED]> wrote: > Does anyone know of a tryly slick way to back up mysql databases. > Right now I am trying to write a script which read-only locks the databases then >runs amanda and then unlocks the data bases. I am having fun doing it > but I see little reason to re-invent the wheel if someone else has already done this. > I also could be going about this in an entirly wrong headed manner. All I know is > I will not have the diskspace to hold an entire mysql hotcopy on disk, so I am > trying to find a way to have amanda back up the database files directly. The > ultimate solution would be to have amanda go through and lock the databases > individualy as it works but that I fear is close to impossible. Oh well. > thanks in advance for any help > -john > > > -- Frank Smith [EMAIL PROTECTED] Systems Administrator Voice: 512-374-4673 Hoover's Online Fax: 512-374-4501
