需求描述:
使用xtrabackup工具对mysql实例中的所有的数据库进行备份,并且将备份的过程输出到指定的日志文件中.
操作过程:
1.使用xtrabacup工具备份mysql实例
xtrabackup --backup -uroot -pmysql \ --target-dir=/home/mysql/workspace/mysql_backup/FullBackup/Full_Backup_2018-04-19 \ 2>/home/mysql/workspace/mysql_backup/FullBackup/Full_Backup_2018-04-19.log
备注:xtrabackup执行过程的内容会输出到STDERR,所以,直接使用>即STDOUT是不能将输出重定向到文件的.--target-dir指定了要将备份写到哪个目录下,--backup就是对mysql实例做备份
2.查看生成的备份文件及日志
[mysql@redhat6 FullBackup]$ ll total 176 drwxr-x--- 17 mysql mysql 4096 Apr 18 19:03 Full_Backup_2018-04-19 -rw-rw-r-- 1 mysql mysql 175655 Apr 18 19:03 Full_Backup_2018-04-19.log #备份日志中是有内容的. [mysql@redhat6 FullBackup]$ pwd /home/mysql/workspace/mysql_backup/FullBackup
查看日志:
-rw-rw-r-- 1 mysql mysql 175655 Apr 18 19:03 Full_Backup_2018-04-19.log [mysql@redhat6 FullBackup]$ pwd /home/mysql/workspace/mysql_backup/FullBackup [mysql@redhat6 FullBackup]$ more Full_Backup_2018-04-19.log 180418 19:02:15 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/tmp/mysql.sock' as 'root' (using password: YES). 180418 19:02:15 version_check Connected to MySQL server 180418 19:02:15 version_check Executing a version check against the server... 180418 19:02:15 version_check Done. 180418 19:02:15 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /tmp/mysql.sock Using server version 5.5.57-log xtrabackup version 2.4.10 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 3198bce) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /mysql/data xtrabackup: open files limit requested 0, set to 65536 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:100M:autoextend xtrabackup: innodb_log_group_home_dir = /mysql/data/ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 5242880 InnoDB: Number of pools: 1 180418 19:02:15 >> log scanned up to (2169910173) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 1077 for employees/employees, old maximum was 0 180418 19:02:16 >> log scanned up to (2169910173) 180418 19:02:17 >> log scanned up to (2169910173) 180418 19:02:18 >> log scanned up to (2169910173) 180418 19:02:19 >> log scanned up to (2169910173) 180418 19:02:20 >> log scanned up to (2169910173) 180418 19:02:20 [01] Copying ./ibdata1 to /home/mysql/workspace/mysql_backup/FullBackup/Full_Backup_2018-04-19/ibdata1 180418 19:02:21 >> log scanned up to (2169910173) 180418 19:02:22 >> log scanned up to (2169910173) 180418 19:02:23 >> log scanned up to (2169910173) 180418 19:02:24 >> log scanned up to (2169910173) 180418 19:02:25 >> log scanned up to (2169910173) 180418 19:02:26 >> log scanned up to (2169910173) 180418 19:02:27 >> log scanned up to (2169910173) 180418 19:02:28 >> log scanned up to (2169910173) 180418 19:02:29 >> log scanned up to (2169910173) 180418 19:02:30 >> log scanned up to (2169910173) 180418 19:02:31 >> log scanned up to (2169910173) 180418 19:02:32 >> log scanned up to (2169910173)
备注:说明全备份没有问题,并且也产生了日志文件.
文档创建时间:2018年4月19日11:46:14