we run mysqlhotcopy script to copy the database to a different slice on the disk, and then make the backup of that slice to a magnetic tape.
/usr/local/mysql/bin/mysqlhotcopy password=your_passwd databasename /path/to/backup/dir mysqlhotcopy is a perl script that locks the table for updates while the copy is being made. This ensures the integrity. If want a more robust solution, I would recommend creating replica(mirror) db server and making backups of the replica server. Saqib Ali --------- http://www.xml-dev.com On Fri, 18 Jul 2003, Michael Sorrentino wrote: > Greetings list > > Currently, I'm using tar to backup the /var/lib/mysql directory four > times a day. Is this sufficient or is it possible for tar to skip over > some files that may be in use? There are a lot of DB's and I need to > make sure I'm not missing data on backup. Any suggestions? > > > -- > redhat-list mailing list > unsubscribe mailto:[EMAIL PROTECTED] > https://www.redhat.com/mailman/listinfo/redhat-list > -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
