Import and export MySQL database commands under Linux

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

1, export the database dbname table structure
Mysqldump-u Root-p-D dbname >db.sql;

2. Export database dbname All table structures and table data (without-D)
Mysqldump-u root-p dbname >db.sql;

3. Export database dbname The structure of a table
Mysqldump-uroot-pdbpasswd-d dbname test>db.sql;

4. Export Database dbname a table (test) Structure and table data (without-D)
Mysqldump-u root-p dbname test>db.sql;

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

Note: There is a command-line mode with SQL command

Import and export MySQL database commands under Linux