Record a MySQL logical backup and recovery Drill

The procedure for recording a MySQL logical backup and recovery drill is roughly as follows: get data from 42.121.189.236 to 192.168.1.119 and then send the data to 192.168.1.110 for recovery. Next, let's take a look at this process. (1) get data from 42.121.189.236 on 192.168.1.119 and send it to 192.168.1.110 [plain] $ mysqldump-udavid-p123-h42.121.189.236 -- single-transaction -- lock-tables -- force -- master-data = 1 -- databases MPEG-4>/tmp/cdio_bak. SQL # tar-jcv-f cdio_bak. SQL .tar.bz2 cdio_bak. SQL # scp cdio_bak. SQL .tar.bz2 192.168.1.110: /tmp/(ii) Restore and verify [plain] # tar-jxv-f cdio_bak. SQL .tar.bz2-C/home/mysql $ mysql-uroot-poracle <cdio_bak. SQL mysql> show databases on 192.168.1.110; + -------------------- + | Database | + ------------------ + | information_schema | b7-| mysql> use b7-; Database mysql> select count (*) from t_visitor; + ---------- + | count (*) | + ---------- + | 313 | + ---------- + By David Lin 2013-06-09Good Luck