How to Backup/Export MYSQL Database Using phpMyadmin
Login to cPanel and click on phpMyAdmin.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/3e2ce817-429b-40c2-a137-0bdb85533de9.png)
Select the database which you wish to backup from the drop down database menu at the left.
In this example, I shall pick "joshipro_wptest1"
_.
Tick the box for "Check all / Check tables having overhead"
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/c01d98da-e0ae-4940-b5e5-4345bbba41a6.png)
Click on "Export" tab.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/d07fe3e8-5627-416a-836a-5a6302890cbb.png)
Select Export Method and the compression format.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/aace81a6-dbc3-4772-a03c-726d5a9e2f57.png)
Click "Go" to begin the export or backup download
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/3e2ce817-429b-40c2-a137-0bdb85533de9.png)
Select the database which you wish to backup from the drop down database menu at the left.
In this example, I shall pick "joshipro_wptest1"
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/89df4a24-4ac5-47e3-ab04-f3e13804ac5d.png)
Tick the box for "Check all / Check tables having overhead"
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/c01d98da-e0ae-4940-b5e5-4345bbba41a6.png)
Click on "Export" tab.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/d07fe3e8-5627-416a-836a-5a6302890cbb.png)
Select Export Method and the compression format.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/aace81a6-dbc3-4772-a03c-726d5a9e2f57.png)
Click "Go" to begin the export or backup download
Updated on: 15/08/2018
Thank you!