Several methods of MySQL export database

MySQL Tutorial export Database Tutorial several methods

Method One

CMD to the MySQL Bin directory with the following command mysqldump--opt-h192.168.0.156-uusername-ppassword--skip-lock-tables databasename> Database.sql
You can change the IP to localhost.
It's even easier if you have navicate. Connect to the database first, select the database, and then select Dump SQL.

Method Two
Go to cmd (note in OS cmd instead of MySQL)
===================
1. Export database (SQL script)
Mysqldump-u user name-p database name > exported file name
Mysqldump-u root-p db_name > Test_db.sql
2.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)

Method Three

Start the MySQL service
/etc/init.d/mysql start

Export the entire database
Mysqldump dbname > C:mydb.sql-u root-p

Import Database
SOURCE Mydb.sql

Mysql-u user name-p database name < database name. sql

More detailed tutorial on importing a database

2.1. Exporting SQL Scripts
On the original database server, you can export the SQL script using the PHP Tutorial MyAdmin tool, or mysqldump (mysqldump command is located in the mysql/bin/directory) command line.
2.1.1 with PHP (www.111cn.net) MyAdmin tool
Export options, select export structure and data, and do not add the drop database and drop table options.
Select the Save As File option, and if you have more data, you can select the gzipped option.
Save the exported SQL file.

2.1.2 with mysqldump command line
Command format
Mysqldump-u user name-p database name > database name. sql
Example:
MYSQLDUMP-UROOT-P ABC > Abc.sql
(Export database ABC to abc.sql file)

When prompted for a password, enter the password for the database user name.

2.2. Create an empty database
Create a database from the main control interface/Control Panel. Assuming that the database name is ABC, the database is full-user abc_f.

2.3. Import SQL scripts into the execution
The same is true of two methods, a phpmyadmin (MySQL database management) tool, or a MySQL command line.
2.3.1 with phpMyAdmin Tools
From the Control Panel, select Create an empty database, click "Manage" and go to the Administration Tools page.
From the SQL menu, browse to select the SQL file you just exported, click "Execute" to download and execute.

Note: phpMyAdmin has a limit on the size of uploaded files, and PHP itself limits the size of uploaded files if the original SQL file
Relatively large, you can first compress it with gzip, for a text file such as SQL file, you can get 1:5 or higher compression rate.
How to use gzip:
# gzip Xxxxx.sql
Get
xxxxx.sql.gz file.

2.3.2 with mysql command line
Command format
Mysql-u user name-p database name < database name. sql
Example:
MYSQL-UABC_F-P ABC < Abc.sql
(Import database ABC from Abc.sql file)

When prompted for a password, enter the password for the database user name.
From:http://www.111cn.net/database/mysql/33830.htm

Several methods of MySQL export database