Linux Import Export database __ Large data

First, the export database with the mysqldump command (note the MySQL installation path, that is, the path of this command):
1. Export Data and table structure:
Mysqldump-u User name-p password database name > database name. sql
#/usr/local/mysql/bin/mysqldump-uroot-p ABC > Abc.sql
Prompt for password after knocking in return

2. Export table structure only
Mysqldump-u User name-p password-d database name > database name. sql
#/usr/local/mysql/bin/mysqldump-uroot-p-D ABC > Abc.sql

NOTE:/usr/local/mysql/bin/---> MySQL data directory

Second, import the database
1, first to build a blank database
Mysql>create database ABC;

2. Import Database
Method One:
(1) Select database
Mysql>use ABC;
(2) Setting up the database encoding
Mysql>set names UTF8;
(3) Import data (note the path to the SQL file)
mysql>source/home/abc/abc.sql;
Method Two:
Mysql-u User name-p password database name < database name. sql
#mysql-UABC_F-P ABC < Abc.sql

It is recommended that you import using the second method.

Note: command line mode with SQL command