Thoughts of Dan

This script will backup your mysql DB using mysqldump, but because mysql dump locks the entire DB, this script only backs up one table at a time, thus only locking one table at a time.       #!/bin/sh # System + MySQL backup script # Copyright (c) 2008 Marchost # This script is licensed under GNU GPL version 2.0 or above # Modified by dfish to use rsync # --------------------------------------------------------------------- echo `date` ######################### ######TO BE MODIFIED##### ### System Setup ### BACKUP= / backups / ### MySQL Setup ### MUSER="foo" MPASS="bar" MHOST="localhost" ### REMOTE SETUP ### RUSER="root" RHOST="192.168.0.70" RPATH=" / backups/db / ." ### MYSQL PATHS ### MYSQL="/home/mysql/mysql-standard-4.1.13-pc-linux-gnu-i686/bin/mysql" MYSQLDUMP="/home/mysql/mysql-standard-4.1.13-pc-linux-gnu-i686/bin/mysqldump"   ######SHOULD NOT NEED TO MAKE MODIFICATION BELOW##### ############...