|
Title: mysqldump Post by: bashconsole on May 09, 2009, 11:52:14 PM NAME
mysqldump - a database backup program SYNOPSIS mysqldump [options] [db_name [tbl_name ...]] http://bashconsole.org/man.1.mysqldump Title: Dump all mysql databases Post by: bashconsole on May 09, 2009, 11:59:08 PM Code: #!/bin/sh ordate=`date -I` mysqldump --all-databases | gzip > /var/backup/mysqlbackup-$date.sql.gz Code: mysqldump --all-databases | bzip2 -c > /var/backup/mysqlbackup-$date.sql.bz2 For cron Code: #!/bin/sh date=`date -I` /usr/bin/mysqldump -uuser --password=password -hlocalhost --all-databases --opt --allow-keywords --flush-logs --hex-blob --quote-names |bzip2 -z9 > /var/database.backup/mysql-$date.sql.bz2 |