使用MEB进行mysql备份
MEB是一个mysql官方的备份工具,具有
使用meb时,我们先需要在mysql 的配置文件中添加必要参数
[root@Wang-01 mysql]# vim /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#慢查询日志
slow_query_log=1
long_query_time=3
log-slow-queries=/var/lib/mysql/slow_query.log
#二进制日志
log-bin=mysql-bin
#指定默认存储引擎为Innodb
default-storage-engine=innodb
innodb_data_home_dir = /var/lib/mysql
innodb_data_file_path=ibdata1:10M:autoextend
innodb_log_group_home_dir=/var/lib/mysql
innodb_log_files_in_group=2
innodb_log_file_size=5242880
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid</