Https://www.cnblogs.com/wangzun/p/6889247.html
Export Database
To use the command directly:
Mysqldump-u root-p ABC >abc.sql
Then enter the password on the return to it;
Mysqldump-u Database link user name-p target database > stored file name
The file is exported to the current directory
Import database (SQL file)
Mysql-u user name-p database name < database name. sql
Mysql-u ABC-P ABC < Abc.sql
Note that the SQL file must be in the current directory, if it is not in the current directory need to add a specific SQL file path after <
Https://www.cnblogs.com/jwlfpzj/articles/7998395.html
Linux under
First, export the database with the mysqldump command (note the installation path of MySQL, which is the path to 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
You will be prompted to enter your password after hitting enter
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 build empty database
Mysql>create database ABC;
2. Import the database
Method One:
(1) Select database
Mysql>use ABC;
(2) Setting 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
MySQL command line import Export data