How to export database in phpstudy

phpstudyHow to export the database

For a system, data is a very important part. The process of system deployment or environment migration is often accompanied by the import and export of data. phpStudy also comes with data import and export functions. The export and export function can be found in the main interface.

1. In order to demonstrate import and export, we first create a database: phpstudy, create a table: user, and insert two pieces of data

2. Open phpStudy-》Mysql Manager-》Mysql import and export

Enter password: root, backup database: phpstudy, click export

Since there was relatively little data, it was successful immediately and the path to the export file was automatically opened.

Open the export file and you can see that it contains the sql statement to create the database.

3. In order to verify the import function, we can put the Data is cleared. It can be seen from the picture that there is no table in the database.

4. Open phpStudy-》Mysql Manager-》Mysql Import and Export

Select the restore file path and click The data backup folder will then be opened automatically. We select the data file we just exported. Fill in the database to be restored to: phpstudy. Click Import, and a black window will appear, flashing by, indicating that the import has been completed.

#5. Check that the previous data has appeared in the database and the import was successful.

Recommended tutorial: phpstudy usage tutorial

The above is the detailed content of How to export database in phpstudy. For more information, please follow other related articles on the PHP Chinese website!