Recover the specified database and table from the mysql full-database backup, and mysql backup

Recover the specified database and table from the mysql full-database backup, and mysql backup

 

 

Requirement: development requires importing data from a certain table on a certain day, while our data is full-database backup.

For example, from newbei_2017-08-31_402794252.tar.bz2, restore the data of bei_table.

I. Backup Policy

Back up full-database data: newbei

Ii. Decompress

Tar xvf newbei_2017-08-31_402793782.tar.bz2 # extracted file name: newbei_2017-08-31. SQL

Sed-e '/./{H; $! D;} '-e 'x;/create table 'bei _ table '/! D; Q' newbei_2017-08-31. SQL> bei_table_2017-08-31. SQL # export CREATE TABLE statement

Grep-I 'insert INTO 'bei _ table' newbei_2017-08-31. SQL> bei_table_2017-08-31. SQL # filter the INSERT statements for exporting bei_table

 

Iii. Import Data

Use beipw

Source bei_table_2017-08-31. SQL;