How to back up mysql database? You can use the mysqldump command to back up the database. This article will introduce it to you. I hope it will be helpful to you.
You can use the mysqldump command to back up the database
1. Open the start menu, search for cmd in the search box below, and open the cmd command Line
2. Enter the command to back up the database
The format is:
mysqldump -u[用户名] -p[密码] 数据库名称 > 文件
Example:
mysqldump -uroot -p123456 test>e:/mysqltest/test.dump
The backup file was saved successfully, as shown in the figure below
Related learning recommendations:mysql video tutorial
The above is the detailed content of How to back up mysql database?. For more information, please follow other related articles on the PHP Chinese website!
