How to export database files in phpmyadmin

How to export the database with phpMyAdmin:

Enter phpMyAdmin

You can find phpMyAdmin in the database section of the Pagoda control panel.

Select the database to be exported

You can see all MySQL databases on the left side of phpMyAdmin, click on the MySQL database you want to export.

Export MySQL database

1. Click the Export tab at the top of the page

2. Select the export method, phpMyAdmin provides Two export methods, Quick – display only the minimal options and Custom – display all possible options. The custom export method allows changing a different number of settings:

Tables. Export only selected tables.

Output. Change the file's character set, filename template and enable compression - MySQL backup files will be compressed. This is convenient if the database is large, as this will reduce the file size.

Format-specific options. Depending on the selected format, different settings can be changed here. For example, you can change the column separator when exporting a database to a CSV file.

It is recommended to use the Quick – display only the minimum options export method.

3. Select the preferred format

4. Press the GO button to start exporting and start downloading the MySQL backup file.

Recommended related articles and tutorials: phpmyadmin tutorial

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