MySQL command line Import Export data

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