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 ( Run as Administrator ):
----------------------------------------------------------------------------------------------
C:\users\dell>f:
F:\>CD Phpstudy
F:\PHPSTUDY>CD MySQL
F:\PHPSTUDY\MYSQL>CD bin
F:\phpstudy\mysql\bin>mysql-uroot-p
Enter Password: * * *
----------------------------------------------------------------------------------------------------------
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
Export Import. sql file under Linux command line