reload
on *.
* to mybackup@
‘localhost‘ identified
by ‘131417‘;
grant create,
insert,
drop,
update on mysql.backup_progress
to mybackup@
‘localhost‘;
grant create,
insert,
drop,
update,
select on mysql.backup_history
to mybackup@
‘localhost‘;
grant super
on *.
* to mybackup@
‘localhost‘;
grant replication client
on *.
* to mybackup@
‘localhost‘;
grant process
on *.
* to mybackup@
‘localhost‘;
grant lock tables,
select,
create,
alter on *.
* to mybackup
@localhost;
grant create,
insert,
drop,
update on mysql.backup_sbt_history
to mybackup@
‘localhost‘;
003、由于mysqbackup是复制文件的方式备份的，所以用于备份的linux用户要对目标路径有相应的权限。
004、执行一次全备
root@localhost>mysqlbackup --user=mybackup --password=131417 --backup-image=/mysql_backup/data/mysql_server.mbi --backup-dir=/mysql_backup/temp backup-to-image
--user:用户名。
--password:密码。
--port:端口，默认值为3306。
--backup-dir:可以看成是mysqlback的工作目录。
--backup-image:备份文件名。
backup-to-image:把所有的备份信息输出到一个备份文件当中。
005、可以校验一下备份文件，用于确定备份是否损坏。
mysqlbackup --backup-image=/mysql_backup/data/mysql_server.mbi validate
MySQLBackup 使用说明
标签：
