How to use MYSQLBACKUP

最新推荐文章于 2025-05-26 14:04:58 发布

转载最新推荐文章于 2025-05-26 14:04:58 发布 · 124 阅读

DBA Notes: 2011/09/16

Cheng Li

How to use MYSQL Enterprise backup (MEB)

MySQL enterprise backup, MEB, is a superset of the InnoDB Hot Backup product. The ibbackup command is available on all platforms, with the same options as before plus some new ones. In particular, the --incremental option enables incremental backups of InnoDB tables.

[mysql@ctmitsdb ~]$ mysqlbackup /home/mysql/data/.my.cnf /home/mysql/backups

mysqlbackup: Starting mysqlbackup with following arguments:
mysqlbackup /home/mysql/data/.my.cnf /backups
mysqlbackup: The unique backup id generated for the current backup operation is 101620
mysqlbackup: IMPORTANT: Please check that backup run completes successfully.
At the end of a successful 'backup' run mysqlbackup
prints "mysqlbackup completed OK!".

[mysql@ctmitsdb ~]$ tail -40 mysql_fullbackup.log

110915 17:54:14 mysqlbackup: INFO: Copying /home/mysql/data/mysql/ibbackup_binlog_marker.ibd (Antelope file format).
mysqlbackup: INFO: A copied database page was modified at 6879155536.
          (This is the highest lsn found on page)
          Scanned log up to lsn 6879155751.
          Was able to parse the log up to lsn 6879155751.
          Maximum page number for a log record 3579
110915 17:54:14 mysqlbackup: INFO: All tables unlocked
mysqlbackup: INFO: All MySQL tables were locked for 456.000 seconds
110915 17:54:14 mysqlbackup: INFO: Full backup completed!
mysqlbackup: INFO: MySQL binlog position: filename ctmitsdb-bin.000038, position 87250992
mysqlbackup: INFO: Backup created in directory '/home/mysql/backup/2011-09-15_17-45-35'
110915 17:54:14 mysqlbackup: INFO: ibbackup_logfile's creation parameters:
          start lsn 6879142400, end lsn 6879155751,
          start checkpoint 6879142785.
InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 Setting log file size to 0 268435456
InnoDB: Progress in MB: 100 200
Setting log file size to 0 268435456
InnoDB: Progress in MB: 100 200
Setting log file size to 0 268435456
InnoDB: Progress in MB: 100 200
mysqlbackup: INFO: We were able to parse ibbackup_logfile up to
          lsn 6879155751.
ibbackup: Last MySQL binlog file position 0 87250992, file name /home/mysql/data/archive/ctmitsdb-bin.000038
mysqlbackup: INFO: The first data file is '/home/mysql/backup/2011-09-15_17-45-35/datadir/ibdata1'
          and the new created log files are at '/home/mysql/backup/2011-09-15_17-45-35/datadir/'
mysqlbackup: INFO: System tablespace file format is Antelope.
110915 17:54:34 mysqlbackup: INFO: Full backup prepared for recovery successfully!

--------------------------------------------------------
   Parameters Summary
---------------------------------------------------------
   Start LSN                  : 6879142400
   End LSN                    : 6879155751
--------------------------------------------------------

mysqlbackup completed OK!

Reference:

Whitepaper: mysql-enterprise-backup-3.5-en.a4

Software: meb-3.5.4-rhel5.x86_64.rpm

U2727P2DT20110915091247.jpg