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