How to quickly back up and restore the database in phpmyadmin?

How to quickly back up and restore the database with phpmyadmin: First log in to the database, 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.

phpmyadmin quick backup and restore database method:

Database export

1. Open the phpMyAmin database path of the program, enter the database account and 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: "Quick" and "Custom". Generally, there are no special requirements. It is enough for us to use the "Quick" export function. Here, "Quick" is selected to export the database by default, and the format is sql (I It is a Mysql database, choose according to your own database), click Execute

3. In the database export window, you can modify the SQL name of the database (the default name 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 on the top navigation on the right "Import" button, you can see the imported formats available here. I will take the sql file imported above as an example, click to select the file,

2. In the pop-up In the file selection box, select the database file we backed up before (here, take the previously exported sql file as an example)

3. After the file selection is successful, click Execute below. Then when you see the success prompt, it means the import is complete

Related tutorial recommendations:phpmyadmin

The above is the detailed content of How to quickly back up and restore the database in phpmyadmin?. For more information, please follow other related articles on the PHP Chinese website!