Recover a library and a table from a MySQL full-library backup

Recover only test_db library from full backup mysql-uroot-proot test_db --one-database <backup.sql recover from full backup only operlog_20180620  Table structure of table from backup query restore table sed-e '/./{h;$!d;} '-E ' x;/create table ' operlog_20180620 '/!d;q ' Trade_log_20180627100605.sql Querying table data from backup grep ' INSERT into ' operlog_20180626 ' Trade_log_20180627100605.sql >data.sql

Recover a library and a table from a MySQL full-library backup