How to export database in mysql?

How to export the database in mysql? The following article will introduce you to 3 methods of exporting a MySQL database. I hope it will be helpful to you.

Mysql export database method:

Method 1

cmd to mysql Use the following command in the bin directory:

 mysqldump --opt -h192.168.0.156 -uusername -ppassword --skip-lock-tables databasename>database.sql

Just change the ip to localhost

If you install navicate, it will be easier. First connect to the database, select the database, and then select dump Just sql

Method 2

Enter cmd (note that it is in os cmd and not in mysql), export the database (sql script), basically Syntax:

mysqldump -u 用户名 -p 数据库名 > 导出的文件名

Example:

mysqldump -u root -p db_name > test_db.sql

You can also export only one table in the database. Basic syntax:

mysqldump -u 用户名 -p 数据库名 表名> 导出的文件名

Example:

mysqldump -u wcnc -p test_db users> test_users.sql

Note: There is no semicolon at the end

Method 3

Start the mysql service

/etc/init.d/mysql start

Export the entire database

mysqldump dbname > c:mydb.sql -u root -p

Related learning recommendations: mysql tutorial(video)

The above is the detailed content of How to export database in mysql?. For more information, please follow other related articles on the PHP Chinese website!