Shulou(Shulou.com)06/01 Report--

Restore a library and a table from a MySQL full backup

1. Full database backup-A

[root@mha2 backup] # mysqldump-uroot-p123456-- default-character-set=utf8-- single-transaction-- extended-insert=false-- hex-blob-- master-data=2-- log-error=/tmp/test.err-- routines-- triggers-- events-- quick-- flush-logs-- all-databases > fulldump.sql

Restore only the report library from the full backup

[root@mha2 backup] # mysql-uroot-p123456 report-- one-database data.sql

Or

Restore a library first, back up a table separately, and restore a table.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.