MySQL database import and Export command under Linux

First view MySQL related directory under Linux
[Email protected]:~# whereis MySQL
Mysql:
/usr/bin/mysql----MySQL Run path
/etc/mysql
/usr/lib/mysql-----MySQL Installation path
/usr/bin/x11/mysql
/usr/share/mysql
/usr/share/man/man1/mysql.1.gz
In addition, there is one:
Var/lib/mysql--------The storage path of the MySQL database data file

Run path determined, execute import, export MySQL database command
First, export the database with the mysqldump command
(Note: CD to MySQL running path, then execute command):
1. Export Data and table structure:
Mysqldump-u User name-p password database name > database name. sql
Mysqldump-uroot-p dbname > dbname. 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
Mysqldump-uroot-p-D dbname > dbname. sql

Second, import the database
1, first build empty database
Mysql>create database dbname;
2. Import the database
Method One:
(1) Select database
Mysql>use dbname;
(2) Setting the database encoding
Mysql>set names UTF8;
(3) Import data (note the path to the SQL file)
Mysql>source/home/xxxx/dbname. sql;
Method Two:
Mysql-u User name-p password database name < database name. sql

MySQL database import and Export command under Linux