MySQL Database Import and Export

MySQL Database Import and Export

When using MySQL DATA, you will always encounter Import and Export situations. Therefore, it is very important to correctly import and export data! The following method is used in the work:

Import:

Import data directly in Mysql:

Mysql> use databaseName;

Mysql> load data infile 'filepath' into table 'tablename'

If you directly use an SQL script file, you can use source:

Log on to the mysql Database Console, such as mysql-u root-p.

Mysql> use Database

Then run the source command. The following parameter is the script file (for example,. SQL used here)

Mysql> source d: \ wcnc_db. SQL

Export:

Export from Linux terminal or shell window or command prompt:

Mysql [-h IP-P port]-u userName-p Password DatabaseName "select * from tableName [where]"> filePathName

You can also use mysqldump. Several common use cases are as follows:

1. Export the entire database

Mysqldump-u username-p Database Name> exported file name

Mysqldump-u wcnc-p smgp_rj_wcnc> wcnc. SQL

2. Export a table

Mysqldump-u user name-p database name Table Name> exported file name

Mysqldump-u wcnc-p smgp_rj_wcnc users> wcnc_users. SQL

3. Export a database structure

Mysqldump-u wcnc-p-d -- add-drop-table smgp_apps_wcnc> d: \ wcnc_db. SQL

-D no data -- add-drop-table adds a drop table before each create statement.

In Mysql, perform the following export operations:

Select * into outfile 'filename' from tableName [where...] (export some or all data in the table)

-------------------------------------- Split line --------------------------------------

Install MySQL in Ubuntu 14.04

MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF

Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL

Build a MySQL Master/Slave server in Ubuntu 14.04

Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS

Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04

MySQL-5.5.38 universal binary Installation

-------------------------------------- Split line --------------------------------------

This article permanently updates the link address: