Home  >  Article  >  Database  >  How to back up mysql database with MySQLAdministrator

How to back up mysql database with MySQLAdministrator

黄舟
黄舟Original
2017-08-10 14:29:551917browse

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

How to back up mysql database with MySQLAdministrator

How to back up mysql database with MySQLAdministrator


2. Click [Backup] on the left 】

How to back up mysql database with MySQLAdministrator


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

How to back up mysql database with MySQLAdministrator


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

How to back up mysql database with MySQLAdministrator


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

How to back up mysql database with MySQLAdministrator

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn