Mysql database porting from server to personal PC method _mysql

First, the use of mysqldump

1, mysqldump Backup Database

1. Enter the MySQL installation file bin directory, such as:d:\mysql5.5\bin>

2. Backing up the database with the mysqldump-uroot-p123 qh>d:\qh.sql command

mysqldump-uroot-p123 Login to database user for root password 123

Qh>d:\qh.sql the database QH back to D:\qh.sql

2, mysqldump Restore the database

1. Create a new, empty database

2. Restore the database with the mysql-uroot-p123 aa<d:\qh.sql command

Restore the D-disk qh.sql to the database AA

Ii. backing up and restoring Databases using SQLyog uitimate-mysql GUI v8.53 (http://www.webyog.com/en/downloads.php)