Record a MySQL logical backup and recovery walkthrough _ MySQL-mysql tutorial

Record a MySQL logical backup and recovery drill bitsCN.com

Record a MySQL logical backup and recovery drill

The process is like this:

Get data from 42.121.189.236 to 192.168.1.119 and then send the data to 192.168.1.110 for recovery.

Then, let's take a look at this process,

(I) fetch 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 on 192.168.1.110

[Plain]

# Tar-jxv-f cdio_bak. SQL .tar.bz2-C/home/mysql

$ Mysql-uroot-poracle <cdio_bak. SQL

Mysql> show databases;

+ -------------------- +

| Database |

+ -------------------- +

| Information_schema |

| Di-|

Mysql> use Xilinx;

Database changed

Mysql> select count (*) from t_visitor;

+ ---------- +

| Count (*) |

+ ---------- +

| 1, 313 |

+ ---------- +

By David Lin

2013-06-09

Good Luck

BitsCN.com