mysql-Learning -13-20170619-mysql Backup Recovery-xtrabackup-2

mysql-Learning -13-20170619-mysql Backup Recovery-xtrabackup-2

"Admin" Wu Bingxi (82565387) 20:34:15
Based on Xtrabackup, you only need to know
If you need to add a backup, you can back up Binlog with compressed packaging:

Without gzip-you can also

To generate a password string:

Innobackupex--no-timestamp-s/tmp/mysql3306.sock-uroot-pwubxwubx--encrypt=aes256--encrypt-key= " 4XZKJLXEAG9IENY1EFWFDCN4LW0LHCFA "/DATA/BACKUP/DB1 Innobackupex--decrypt=aes256--encrypt-key=" 4XZKJLXEAG9IENY1EFWFDCN4LW0LHCFA "/DATA/BACKUP/DB1--remove-original

Make a backup of the database:

Recovery:

Use mysqldump Backup (back up the table structure with the-d command--no-data)

Ignoring gtid using the-F recovery Library

Clear out the wubx of the table space, after clearing out only the WUBX.FRM table structure of the file

ALTER TABLE WUBX discard tablespace;

Cp/data/backup/zst/wubx.cfg. Chown-r Mysql:mysql wubx.* Then execute the import statement and you'll see that the data is coming.

Here's what the teacher summed up: mysql>alter table TB discard tablespace;
cp/data/backup/zst/wubx.cfg.
cp/data/backup/zst/wubx.ibd.
chown-r mysql:mysql wubx.*
mysql>alter table TB import tablespace;

Support for tablespace transfer after MySQL 5.6

Today's keynote is as follows:

"Admin" Wu Bingxi (82565387) 22:28:01
1. Tar-streaming backup
"Admin" Wu Bingxi (82565387) 22:28:08
2. Remote Backup
"Admin" Wu Bingxi (82565387) 22:28:16
NC, WDT, BT
"Admin" Wu Bingxi (82565387) 22:29:22
3. Encrypted backup
"Admin" Wu Bingxi (82565387) 22:29:37
4. Backing up individual libraries and innodb table space transfers

Format of Binlog:

https://dev.mysql.com/doc/internals/en/

Binlog_event.h

mysql-Learning -13-20170619-mysql Backup Recovery-xtrabackup-2