My strategy is:
1. Build a database list from the files in the mysql data directory.
2. For each database run the command:
mysqldump --tab=$BackUpDir --lock-tables --quick --user=$User
--password=$Password --verbose $DB
BackUpDir points to enough disk to hold the backups and DB is the
particular database being backed up.
3. Flush the log files using the command:
mysqladmin --user=$User --password=$Password flush-logs
Then dsmc is used to backup the BackUpDir and the log files.
Jim
-----Original Message-----
From: Gerald Wichmann [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 6:32 PM
To: [EMAIL PROTECTED]
Subject: MySQL on Linux
Is it possible to backup MySQL on Linux while the DB is up and running and
get a good back? (i.e. a hot backup)
Gerald Wichmann
Systems Engineer
Sansia System Solutions
408-844-8893 work
408-884-9801 fax
