1. export Database: mysqldump Command 1. export data and table structure: mysqldump-u username-p password database name sqlusrlocalmysqlbinmysqldump-uroot-pabcabcsql. after you press enter, you will be prompted to enter the password.
1. export the database:
Mysqldump command
1. export data and table structure:
Mysqldump-u username-p password database name> database name. SQL
#/Usr/local/mysql/bin/mysqldump-uroot-p abc> abc. SQL
After you press enter, you will be prompted to enter the password
2. export only the table structure
Mysqldump-u username-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
2. import the database:
1. First, create an empty database
Mysql> create database abc;
2. import database
Method 1:
(1) select a database
Mysql> use abc;
(2) Set Database encoding
Mysql> set names utf8;
(3) import data (note the path of the SQL file)
Mysql> source/home/abc. SQL;
Method 2:
Mysql-u username-p password database name <database name. SQL
# Mysql-uabc_f-p abc <abc. SQL
We recommend that you use the second method for import.
Note: the command line mode and SQL command are available.