MySQL Export Import data

Export database (SQL script)

Mysqldump-u user name-p database name > exported file name
Mysqldump-u root-p--databases db_name > Test_db.sql # #得到整个数据库, the most comprehensive; do not--databases, is not enough information comprehensive

MySQL Export database a table

Mysqldump-u user name-P database name Table name > exported file name
Mysqldump-u wcnc-p test_db users> test_users.sql # # (end no semicolon) get table MY_10 in database students, simple

MySQL Import SQL file

1, enter mysql:mysql-u user name-P
Input command line: Mysql-u root-p (input will also let you enter the MySQL password)
2, create the database you want to build in Mysql-front, this is an empty database, such as create a new target database named News (may error, do not bother him)
Input: Mysql>use Target database name
Input command line: Mysql>use news;
3, import file: Mysql>source The source file name of the import;
Input command line: Mysql>source news.sql;

The following excerpt from http://www.cnblogs.com/yuwensong/p/3955834.html

Under Window

1. Export the entire database

Mysqldump-u user name-p database name > exported file name
Mysqldump-u dbuser-p dbname > Dbname.sql

2. Export a table

Mysqldump-u user name-P database name Table name > exported file name
Mysqldump-u dbuser-p dbname users> dbname_users.sql

3. Export a database structure

Mysqldump-u Dbuser-p-D--add-drop-table dbname >d:/dbname_db.sql
-D No data--add-drop-table add a drop table before each CREATE statement

4. Import the database

Common source Commands
Enter the MySQL database console, as
Mysql-u root-p
Mysql>use Database
Then use the source command, followed by the script file (for example, the. SQL used here)
Mysql>source D:/dbname.sql

Linux under

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

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

MySQL Export Import data