Knowledge Base
How can I backup a database using phpMyAdmin?
From your cPanel account login to phpMyAdmin section and follow the below steps to create database backups.
Select the database name from the left handside of window
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-620.png)
Click on ‘Export’ option located at top of window
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-622.png)
You will find two options ‘Quick’ and ‘Custom’, select ‘Quick’ option, ‘Custom’ option allows you to select the specific database files for backups.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-623.png)
From the drop-down menu of ‘Format’ select ‘SQL’ option
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-624.png)
Click on the ‘Export’ button
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-625.png)
After clicking on ‘Export’ option a file backup of database will be created and file will be saved on your computer and will have .sql extension as shown below.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-626.png)