mysql xtrabackup在windows平臺(tái)的備份測(cè)試是怎么樣的

179次閱讀

共計(jì) 3526 個(gè)字符，預(yù)計(jì)需要花費(fèi) 9 分鐘才能閱讀完成。

mysql xtrabackup 在 windows 平臺(tái)的備份測(cè)試是怎么樣的，很多新手對(duì)此不是很清楚，為了幫助大家解決這個(gè)難題，下面丸趣 TV 小編將為大家詳細(xì)講解，有這方面需求的人可以來(lái)學(xué)習(xí)下，希望你能有所收獲。

Xtrabackup 有 2 款主要工具：xtrabackup 和 innobackupex
xtrabackup 只能備份和恢復(fù) innodb，而且只備份.ibd 文件，.frm 文件它不管，恢復(fù)時(shí) DBA 要自己提供
innobackupex 能備份和恢復(fù) MyISAM 文件及.frm 文件，并且對(duì) xtrabackup 作了友好的封裝，所以可用它進(jìn)行全庫(kù)備份

下載完解壓縮到 C 盤 xtrabackup 目錄下, 發(fā)現(xiàn)共有 4 個(gè)文件,xtrabackup.exe 是可執(zhí)行文件:

C:\xtrabackup dir
驅(qū)動(dòng)器 C 中的卷是 Windows8_OS
卷的序列號(hào)是 0E54-579B

C:\xtrabackup 的目錄

2016/06/03 09:42
.
2016/06/03 09:42
..
2009/12/08 14:37 6,656 cat.exe
2003/10/23 17:35 135,680 grep.exe
2011/04/21 15:23 90,876 innobackupex.pl
2011/04/20 11:39 4,863,488 xtrabackup.exe

這里我們用 xtrabackup 命令進(jìn)行 innodb 全庫(kù)備份測(cè)試:
xtrabackup 命令的用法:
Usage: [C:\xtrabackup\xtrabackup [–defaults-file=#] –backup | C:\xtrabackup\xtrabackup [–defaults-file=#] –prepare] [OPTIONS]

建立 innodb 測(cè)試庫(kù):

mysql create database duansf;
Query OK, 1 row affected (0.17 sec)

mysql use duansf
Database changed
mysql
mysql
mysql
mysql
mysql create table dsf(id int);
Query OK, 0 rows affected (0.37 sec)

mysql insert into dsf values(1);
Query OK, 1 row affected (0.11 sec)

mysql insert into dsf values(2);
Query OK, 1 row affected (0.14 sec)

mysql insert into dsf values(3);
Query OK, 1 row affected (0.06 sec)

mysql insert into dsf values(4);
Query OK, 1 row affected (0.17 sec)

mysql insert into dsf values(5);
Query OK, 1 row affected (0.09 sec)

mysql select * from dsf;
+——+
| id |
+——+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
+——+
5 rows in set (0.03 sec)

mysql

查看數(shù)據(jù)文件所在目錄:

mysql
完全備份:
C:\xtrabackup\xtrabackup –target-dir=C:\xtrabackup\full –backup –datadir= C:\ProgramData\MySQL\MySQL Server 5.5\Data\

c:\xtrabackup C:\xtrabackup\xtrabackup –target-dir=C:\xtrabackup\full –backup
–datadir= C:\ProgramData\MySQL\MySQL Server 5.5\Data\duansf
C:\xtrabackup\xtrabackup Ver undefined Rev undefined for 5.5.9 Win64 (x86)
xtrabackup: cd to C:\ProgramData\MySQL\MySQL Server 5.5\Data\duansf
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_data_home_dir = .\
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = .\
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 5242880
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
160603 10:32:56 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
xtrabackup: Something wrong with source files…

發(fā)現(xiàn)有報(bào)錯(cuò)，后來(lái)研究了一下，把 C:\Program Files (x86)\MySQL\MySQL Server 5.5\my.ini 拷貝到 c:\xtrabackup 目錄下再執(zhí)行以下命令后測(cè)試通過(guò):
c:\xtrabackup xtrabackup.exe –defaults-file=C:\xtrabackup\my.ini –backup –target-dir=C:\xtrabackup\full
xtrabackup.exe Ver undefined Rev undefined for 5.5.9 Win64 (x86)
xtrabackup: cd to C:/ProgramData/MySQL/MySQL Server 5.5/Data/
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_data_home_dir = .\
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = .\
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 118489088
log scanned up to (1625547)
[01] Copying .\ibdata1
to C:\xtrabackup\full/ibdata1
[01] …done
xtrabackup: The latest check point (for incremental): 1625547
xtrabackup: Stopping log copying thread.. log scanned up to (1625547)

xtrabackup: Transaction log of lsn (1625547) to (1625547) was copied.

注意: 如果重復(fù)執(zhí)行 xtrabackup 命令執(zhí)行備份就會(huì)報(bào)錯(cuò)，我猜測(cè)這可能是由于 xtrabackup 在 windows 平臺(tái)只是個(gè)測(cè)試版，沒(méi)有發(fā)布正式版，因此
生產(chǎn)環(huán)境還是慎用 windows 平臺(tái)版本。

看完上述內(nèi)容是否對(duì)您有幫助呢？如果還想對(duì)相關(guān)知識(shí)有進(jìn)一步的了解或閱讀更多相關(guān)文章，請(qǐng)關(guān)注丸趣 TV 行業(yè)資訊頻道，感謝您對(duì)丸趣 TV 的支持。

正文完