How to back up mysql database?

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!