Import and export MySQL database commands under Linux

First, export the database:

mysqldump 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

We recommend that you use the second method of importing.

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

Import and export MySQL database commands under Linux