MySQL常见备份方案有以下三种:
mysqldump + binlog
lvm + binlog
xtrabackup
本例为方便演示,数据库里面数据为空。下面开始动手
mkdir /opt/backup #创建备份目录
mkdir-p /data/3309/{data,binlog}
cd/usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/data/3309/data/ --basedir=/usr/local/mysql/chown mysql.mysql-R /data/3309/cp support-files/my-small.cnf /data/3309/my.cnf #提供配置文件
vim/data/3309/my.cnf #编辑配置文件
[client]
#password = your_password
port = 3309
socket = /tmp/mysql.sock4
# The MySQL server
[mysqld]
port = 3309
socket = /tmp/mysql.sock4
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
datadir = /data/3309/data
server-id = 3309
log-bin=/data/3309/binlog/mysql-bin #二进制日志位置
binlog_format=mixed #二进制日志格式
log-error = /data/3309/mysql-err #错误日志位置
innodb_file_per_table = 1 #为每一个新数据表创建一个表空间文件
sync_binlog = 1 #写二进制日志的时候,同步到磁盘上面
cp /data/3309/my.cnf /opt/backup/ #备份配置文件
mysqld_safe --defaults-file=/data/3309/my.cnf & #启动mysql
1、利用mysqldump完全备份mysql,配合二进制日志备份实现增量备份
mysqldump 选项请参考http://wangweiak47.blog.51cto.com/2337362/1589304
1.1提供模拟数据
mysql -S /tmp/mysql.sock4 #连接mysql<