MySQL Import export SQL file

MySQL Import export SQL file

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

1. Import data to a database

mysql-uroot-d database name

1. Import data to a table in a database

MYSQL-UROOT-D Database Name Table name

D:\apmserv5.2.6\mysql5.1\bin>mysqldump-u root-p ERP lightinthebox_tags > Ligh

Tinthebox.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

This article is from the "Technical Achievement Dream" blog, please be sure to keep this source http://20145520.blog.51cto.com/9112173/1912068

MySQL Import export SQL file