MySQL Database Export Full Version (Export Database, export table, export database structure)

When you use mysqlce to export database scripts, an exception occurs if the database contains Chinese content.

Now, you can use mysqldump.exe to directly export the database script as follows:

Step one

Run cmd to open the ConsoleProgram

Step two redirects the current directory to the mysqldump.exe directory

Enter the cd c: \ Program Files \ mysql \ MySQL Server 5.1 \ bin command

Running result c: \ Program Files \ mysql \ MySQL Server 5.1 \ bin

 

Step three input the export script command

Input: mysqldump-u username-P Database Name> exported file name

Example: mysqldump-u root-P ydgz> D: \ ydgz20100901. SQL

 

Other export commands
1. 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
2. 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.