Home Database phpMyAdmin How to export database files in phpmyadmin

How to export database files in phpmyadmin

Dec 16, 2019 pm 05:01 PM
phpmyadmin database

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.

How to export database files in phpmyadmin

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.

How to export database files in phpmyadmin

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.

How to export database files in phpmyadmin

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!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Where does the wordpress database exist? Where does the wordpress database exist? Apr 15, 2024 pm 10:39 PM

Where does the wordpress database exist?

What should I do if navicat cannot connect? What should I do if navicat cannot connect? Apr 23, 2024 am 10:00 AM

What should I do if navicat cannot connect?

How to change the default password of Empire CMS How to change the default password of Empire CMS Apr 16, 2024 pm 03:21 PM

How to change the default password of Empire CMS

How to check if navicat forgets root password How to check if navicat forgets root password Apr 24, 2024 am 12:06 AM

How to check if navicat forgets root password

Detailed tutorial on establishing a database connection using MySQLi in PHP Detailed tutorial on establishing a database connection using MySQLi in PHP Jun 04, 2024 pm 01:42 PM

Detailed tutorial on establishing a database connection using MySQLi in PHP

What is the wordpress article database? What is the wordpress article database? Apr 16, 2024 am 11:12 AM

What is the wordpress article database?

How does Hibernate implement polymorphic mapping? How does Hibernate implement polymorphic mapping? Apr 17, 2024 pm 12:09 PM

How does Hibernate implement polymorphic mapping?

iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos Jul 18, 2024 am 05:48 AM

iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos

See all articles