Mysql两种单机热备方案

Mysql有两种备份方案：
1.mysql热备：mysqldump
脚本执行：
automysqlbackup.sh.2.5 （网上有下载的脚本）

# Username to access the MySQL server e.g. dbuser
USERNAME=root

# Username to access the MySQL server e.g. password
PASSWORD=password

# Host name (or IP address) of MySQL server e.g localhost
DBHOST=localhost

# List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3"
DBNAMES="php mysql test"(要备份的数据库)

# Backup directory location e.g /backups
BACKUPDIR="/home/mysql-backup"（存放备份数据库的目录）


[root@localhost mysql-backup]# ls
daily  monthly  weekly

[root@localhost daily]# ls
mysql  php  test
[root@localhost mysql]# ls
mysql_2009-07-06_05h41m.Monday.sql  mysql_2009-07-06_06h23m.Monday.sql.gz


2.mysql热备：mysqlhotcopy
PERL-DBD模块安装
yum -y install perl-DBD-mysql*
编写shell脚本内容：
#!/bin/bash
dateDIR=`date +"%y-%m-%d"`
mkdir -p /bak/databases/$dateDIR
user=root
password=123456
for i in `/usr/local/mysql/bin/mysql -u$user -p$password -e "show databases" | grep -v "Database"`
do
  /usr/local/mysql/bin/mysqlhotcopy -u $user -p $password $i /bak/databases/$dateDIR
done
备份存放mysql的目录：/back/databases

这两者相比较后者速度比较快。


再放到 vi /etc/crontab:
0  0  * * * /srv/mysqlhotcopy.sh