How to Export a MySQL Database Using phpMyAdmin
This guide details the process for creating a backup file (export) of one of your MySQL databases directly through the phpMyAdmin interface accessible via cPanel.
Step 1: Accessing phpMyAdmin
- Log in to your cPanel control panel.
- In the cPanel main interface, navigate to the Databases category and click on the phpMyAdmin link.
Step 2: Selecting the Database and Export Options
- Once the phpMyAdmin application has loaded, select the specific database you wish to export from the list provided on the left-hand navigation pane.
- Click on the Export tab located at the top of the main working area, and then choose an export option:
- Quick - This option exports the entire database using a set of convenient default settings.
- Custom - This option allows you to select individual tables to export, or modify advanced export parameters such as file format and compression.
Step 3: Initiating the Export
- Click on the Go button at the bottom of the page to initiate the database export process. The resulting SQL file will typically be downloaded directly to your computer.
The database file has been successfully exported and saved to your local machine.
