使用mysqlbackup从已经产生的备份生成为单个文件

郑全

如果前面已经使用 mysqlbackup -uroot -proot --socket=/usr/local/mysql/mysql.sock  --backup_dir=/u01/dbback/ copy-back

产生了多个文件备份，还可以直接利用这个已经产生的备份，生成一个单个文件。

 

方法为 ：在最后加一个参数 ：backup-dir-to-image

 

具体运行如下 ：

 

运行之前为：

[root@sztech1 dbback]# ls -ltr
总用量 1916316
-rw-r--r--  1 root root        246 4月  24 08:15 backup-my.cnf
-rw-r--r--  1 root root       3810 4月  24 08:15 server-my.cnf
-rw-r--r--  1 root root      12752 4月  24 08:15 server-all.cnf
drwx------ 11 root root       4096 4月  24 08:15 datadir
drwx------  2 root root       4096 4月  24 09:47 meta

运行备份：

 

[root@sztech1 ~]# mysqlbackup -uroot -proot --socket=/usr/local/mysql/mysql.sock  --backup_dir=/u01/dbback/ --backup-image=mybackup.bak backup-dir-to-image
MySQL Enterprise Backup version 3.11.0 Linux-3.8.13-16.2.1.el6uek.x86_64-x86_64 [2014/08/26]
Copyright (c) 2003, 2014, Oracle and/or its affiliates. All Rights Reserved.

 mysqlbackup: INFO: Starting with following command line ...
 mysqlbackup -uroot -pxxxx --socket=/usr/local/mysql/mysql.sock
        --backup_dir=/u01/dbback/ --backup-image=mybackup.bak
        backup-dir-to-image

 mysqlbackup: INFO:
IMPORTANT: Please check that mysqlbackup run completes successfully.
           At the end of a successful 'backup-dir-to-image' run mysqlbackup
           prints "mysqlbackup completed OK!".

150424 09:47:14 mysqlbackup: INFO: MEB logfile created at /u01/dbback/meta/MEB_2015-04-24.09-47-14_backup_dir_to_image.log

 mysqlbackup: INFO: Creating 14 buffers each of size 16777216.
150424 09:47:14 mysqlbackup: INFO: Backup-dir to image operation starts with following threads
                1 read-threads    1 write-threads
150424 09:47:14 mysqlbackup: INFO: Adding database directory: meta
150424 09:47:14 mysqlbackup: INFO: Adding database directory: datadir
 mysqlbackup: Progress in MB: 200 400 600 800 1000 1200 1400
150424 09:47:24 mysqlbackup: INFO: Copying /u01/dbback/datadir/ibdata1.
 mysqlbackup: Progress in MB: 1600
150424 09:47:25 mysqlbackup: INFO: Copying /u01/dbback/datadir/world/city.ibd.
150424 09:47:25 mysqlbackup: INFO: Copying /u01/dbback/datadir/world/country.ibd.
150424 09:47:25 mysqlbackup: INFO: Copying /u01/dbback/datadir/world/countrylanguage.ibd.
150424 09:47:25 mysqlbackup: INFO: Copying /u01/dbback/datadir/world/deletedcity.ibd.
150424 09:47:25 mysqlbackup: INFO: Copying /u01/dbback/datadir/world/mytable.ibd.
150424 09:47:25 mysqlbackup: INFO: Adding database directory: datadir/world
150424 09:47:25 mysqlbackup: INFO: Copying /u01/dbback/datadir/sztech/dept.ibd.
150424 09:47:25 mysqlbackup: INFO: Copying /u01/dbback/datadir/sztech/emp.ibd.
150424 09:47:25 mysqlbackup: INFO: Copying /u01/dbback/datadir/sztech/emp_bak.ibd.
150424 09:47:25 mysqlbackup: INFO: Copying /u01/dbback/datadir/sztech/emp_bak1.ibd.
150424 09:47:25 mysqlbackup: INFO: Adding database directory: datadir/test
150424 09:47:25 mysqlbackup: INFO: Adding database directory: datadir/sztech
150424 09:47:25 mysqlbackup: INFO: Adding database directory: datadir/sys
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/actor.ibd.
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/address.ibd.
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/category.ibd.
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/city.ibd.
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/country.ibd.
150424 09:47:26 mysqlbackup: INFO: Adding database directory: datadir/sakila
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/customer.ibd.
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/film.ibd.
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/film_actor.ibd.
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/film_category.ibd.
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/inventory.ibd.
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/language.ibd.
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/payment.ibd.
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/rental.ibd.
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/staff.ibd.
150424 09:47:26 mysqlbackup: INFO: Copying /u01/dbback/datadir/sakila/store.ibd.
150424 09:47:26 mysqlbackup: INFO: Adding database directory: datadir/performance_schema
150424 09:47:27 mysqlbackup: INFO: Adding database directory: datadir/mysql
150424 09:47:27 mysqlbackup: INFO: Copying /u01/dbback/datadir/mysql/innodb_index_stats.ibd.
150424 09:47:27 mysqlbackup: INFO: Copying /u01/dbback/datadir/mysql/innodb_table_stats.ibd.
150424 09:47:27 mysqlbackup: INFO: Copying /u01/dbback/datadir/mysql/slave_master_info.ibd.
150424 09:47:27 mysqlbackup: INFO: Copying /u01/dbback/datadir/mysql/slave_relay_log_info.ibd.
150424 09:47:27 mysqlbackup: INFO: Copying /u01/dbback/datadir/mysql/slave_worker_info.ibd.
150424 09:47:27 mysqlbackup: INFO: Copying /u01/dbback/datadir/employees/departments.ibd.
150424 09:47:27 mysqlbackup: INFO: Copying /u01/dbback/datadir/employees/dept_emp.ibd.
150424 09:47:27 mysqlbackup: INFO: Adding database directory: datadir/innodb_memcache
150424 09:47:27 mysqlbackup: INFO: Adding database directory: datadir/employees
150424 09:47:27 mysqlbackup: INFO: Copying /u01/dbback/datadir/employees/dept_manager.ibd.
150424 09:47:27 mysqlbackup: INFO: Copying /u01/dbback/datadir/employees/employees.ibd.
150424 09:47:28 mysqlbackup: INFO: Copying /u01/dbback/datadir/employees/salaries.ibd.
 mysqlbackup: Progress in MB: 1800
150424 09:47:36 mysqlbackup: INFO: Copying /u01/dbback/datadir/employees/titles.ibd.
150424 09:47:38 mysqlbackup: INFO: Backup-dir to image operation completed successfully.
150424 09:47:38 mysqlbackup: INFO: Backup image created successfully.
 mysqlbackup: INFO: Image Path = /u01/dbback/mybackup.bak

mysqlbackup completed OK!
[root@sztech1 ~]#

 

 

备份之后，再查看：

 

[root@sztech1 dbback]# pwd
/u01/dbback
[root@sztech1 dbback]# ls -ltr
总用量 1916316
-rw-r--r--  1 root root        246 4月  24 08:15 backup-my.cnf
-rw-r--r--  1 root root       3810 4月  24 08:15 server-my.cnf
-rw-r--r--  1 root root      12752 4月  24 08:15 server-all.cnf
drwx------ 11 root root       4096 4月  24 08:15 datadir
drwx------  2 root root       4096 4月  24 09:47 meta
-rw-r--r--  1 root root 1962266884 4月  24 09:47 mybackup.bak
[root@sztech1 dbback]# du -sk *
4       backup-my.cnf
1916872 datadir
136     meta
1916284 mybackup.bak
16      server-all.cnf
4       server-my.cnf