MySQL Backup

http://dev.mysql.com/doc/refman/5.0/en/backup-strategy-example.html

main command:

shell> mysqldump -uroot -p --single-transaction --flush-logs --master-data=2\
 --all-databases > db.sql

backup script
[code]
#!/bin/sh

BACKUP_DIR="/backup"

ROOT_PASSWORD="password"

DATE=`date +%y%m%d`

SQL_FILE=db$DATE.sql
TGZ_FILE=db$DATE.tgz

cd $BACKUP_DIR

mysqldump -uroot -p$ROOT_PASSWORD --single-transaction --flush-logs --master-data=2 --all-databases > $SQL_FILE

tar zcvf $TGZ_FILE $SQL_FILE

rm $SQL_FILE
[/code]