How to back up mysql database with MySQLAdministrator

Backing up the mysql database is a very important thing. Of course, there are many ways to back up the mysql database. Today I will describe to you how to use mysqladministrator to back up the mysql database.

1. Open mysqladministrator and enter the login user and password of the mysql database

2. Click [Backup] on the left 】

3. Click [New Project] in the lower right corner to create a new backup project

4. Data backup name, select the database that needs to be backed up, and add Go to the backup area on the right

5. Click [Perform Backup Now] and select the location to backup to.

Note

When entering the username and password of the mysql database, if the database user is not a local user, you need to increase the mysql user permissions so that any host can access

The above is the detailed content of How to back up mysql database with MySQLAdministrator. For more information, please follow other related articles on the PHP Chinese website!