November 7 2017

使用mysqlbackup时会自动记录备份的信息

使用mysqlbackup时会自动记录备份的信息
当使用mysqlbackup的时候会自动的在mysql的mysql库里建两张表:backup_history/backup_progress
一张表用来存放备份的记录,另外一张表用来存放备份进程的信息

backup_history表里每一次备份会记录一条记录,用来标识备份的命令,起止时间,是否有错,BINLOG的文件和位置lsn的文件和位置,innodb的各种信息。

backup_progress表里每一次备份会存四条记录:
| 15099804616273176 | mysqlbackup | 0 | NO_ERROR | 2017-11-06 23:01:03 | Started mysqlbackup.
| 15099804616273176 | mysqlbackup | 0 | NO_ERROR | 2017-11-06 23:14:57 | mysqlbackup locking tables and copying .frm + other engines data. |
| 15099804616273176 | mysqlbackup | 0 | NO_ERROR | 2017-11-06 23:15:00 | mysqlbackup unlocked the tables
| 15099804616273176 | mysqlbackup | 0 | NO_ERROR | 2017-11-06 23:15:00 | mysqlbackup returns success.
用来标识状态



Copyright 2019. All rights reserved.

Posted 2017年11月7日 by ucjmh in category "mysql

Leave a Reply

Your email address will not be published. Required fields are marked *