MySQL Database data Information migration

Environment Kernel Information:

[Email protected] ~]# uname-alinux lodboyedu-01 2.6.32-696.el6.x86_64 #1 SMP Tue Mar 19:29:05 UTC x86_64 x86_64 x86_64 Gnu/linux

backing up data in a database

[Email protected] tools]#/application/mysql/bin/mysqldump-u root-p123456--all-databases  >/tmp/bak.sql

Remote transfer of backup data to a new database server for recovery

172.16. 1.51:/tmp/

Data recovery

/application/mysql/bin/mysql-u root-p123456 </tmp/bak.sql
Description: On the new database server, import the file you just sent to the MySQL database.

MySQL Database data Information migration