MySQL Export Import database table

1. Download the database

Mysqldump db_name-h 192.168.5.162-uroot-p >/var/www/db_name.sql (this can be customized)

2. Download a table in the database:

mysqldump db_name table_name-h 192.168.5.162-uroot-p >/var/www/table_name.sql

3. Import the imported database into our local database

First we have to create a new database, which is the database we are going to import.

MySQL created database-h 127.0.0.1-uroot-p </var/www/db_name.sql

4. Import the data sheet into the database we need

MySQL need to import database name-H 127.0.0.1-uroot-p </var/www/db_name.sql

3rd, 4 points are based on the 1th, 2 points to interact with, we and easy to see 3rd, 4 points are roughly the same.

MySQL Export Import database table