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

This article mainly introduces the method of exporting database files from phpmyadmin, which is very detailed and has certain reference value. Friends who are interested must finish reading it.

How phpMyAdmin exports the database:

Enter phpMyAdmin

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

Select the database to export

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

Export MySQL database

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

two。 Choose the export method. PhpMyAdmin provides two export methods, Quick-display only the minimal options and Custom-display all possible options. Custom export methods allow you to change the number of different settings:

Tables. Only the selected tables are exported.

Output. Change the character set of the file, the file name template and enable compression-MySQL backup files will be compressed. This is convenient if the database is large because it reduces the size of the file.

Format-specific options. Depending on the format you choose, you can change different settings here. For example, you can change the column delimiter when you export a database to an CSV file.

The Quick-display only the minimum options export method is recommended.

3. Select the preferred format

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

The above is all the contents of this article "how to export database files from phpmyadmin". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.