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!