I have to agree. Dumping the database is the way. In fact, although there are third party utilities that will allow you to backup a live Oracle database without stopping it, they cost a fortune, they are only licensed on an individual machine basis, and they do not have support for AMANDA.
I backup our 24*7*365 Oracle9i database by doing an export (the Oracle equiv. to MySQL's dump) and backing up the resulting .dmp file. In the event a recovery is required I can then drop the schema contents and import the dump file to restore to the latest backup. Yes, I am backing up a live Oracle instance with AMANDA via SAMBA. Keith D. Keith Higgs <mailto:[EMAIL PROTECTED]> x0559 Case Western Reserve University, Webmaster - University Library Additional Information at http://www.cwru.edu/UL/ and http://keith.cwru.edu/ "Follow the white rabbit." > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bort, Paul > Sent: Wednesday, April 02, 2003 03:40 PM > To: [EMAIL PROTECTED] > Subject: RE: Backing up MySQL tables > > > Dumping the database and then backing up the dump is the > right way to go. > Think of the dump as a snapshot of the database. By backing > up the snapshot, > you know you're getting a consistent and restorable backup. If you're > worried about the disk space it takes, you can compress it. > I've seen this > method used for MySQL, PostgreSQL, MS SQL, and Oracle. > > > -----Original Message----- > > From: Alex Thurlow [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, April 02, 2003 1:28 PM > > To: [EMAIL PROTECTED] > > Subject: Backing up MySQL tables > > > > > > I need to start backing up MySQL tables on one of my > > machines, but I've > > heard that to you run the risk of table corruption if you > > just copy the > > mysql directory while MySQL is running. Stopping the > > database is not an > > option, and the only solution I've come up with is having > > another script do > > a mysql dump and then backing up that. It seems like a waste > > of time and > > resources to basically do 2 backups though. I was just > > wondering what > > anyone here does for MySQL backups on their own systems? > > > > Alex Thurlow > > >
