Shulou(Shulou.com)06/01 Report--

This article is about how phpmyadmin quickly backs up and restores databases. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

The method for phpmyadmin to quickly back up and restore the database: first log in to the database and click * * Export * * and select * * Quick * *; then modify the sql name and select the save path; then select the database, click * * Import * *, and select the backed up database file; finally, click * * execute * *.

Methods for phpmyadmin to quickly back up and restore databases:

Database export

1. Open the phpMyAmin database path of the program, enter the database account password to enter the database, select the database we want to back up, and then click the "Export" menu bar at the top on the right.

2. You can see that there are two export methods: "fast" and "custom". Generally, there are no special requirements. It is enough for us to use the "fast" export function. Here, we choose "fast" to export the database by default, and select sql in the format (mine is the Mysql database, which is selected according to your own database). Click execute.

3. In the database export window, you can modify the sql name of the database (default is the database name), select the save path, and then click download.

Database import

1. Enter the phpMyAdmin database, create the database, then select the database, and click the "Import" button at the top on the right. Here you can see that the imported format is optional. I will take the imported sql file above as an example, and click to select a file.

2. Select the database file we backed up before in the pop-up Select File box (here take the previously exported sql file as an example)

3. After selecting the file successfully, click execute below, and then see the successful prompt to indicate that the import is complete.

Thank you for reading! About phpmyadmin how to quickly backup and restore the database to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.