- Access your database via PHPMyAdmin in your cPanel
- On the phpMyAdmin page, click Export under MySQL.
- In the Export field on the left side of the View Dump pane, select the database you would like to export.
- Select your options in the SQL options pane. Click the Save as file checkbox and name the file.
- When you are satisfied with your options, click the Go button. You are prompted to download the file.
Your database has been exported.
Export Selected Tables Within a Database- Access your database via PHPMyAdmin in your cPanel.
- Click on the Databases icon under MySQL.
- Click the database name you want to export tables from.
- Click the Export tab.
- In the Export field on the left side of the View Dump pane, select the tables you would like to export. Use the CTRL-key to select multiple tables.
- Select your options in the SQL options pane. Click the Save as file checkbox and name the file.
- When you are satisfied with your options, click the Go button. You are prompted to download the file.
The selected tables have been exported.