1. First login to your cPanel.
2. Click on phpMyAdmin, under databases panel.
![](https://s15.postimg.cc/e0m5otmwr/phpmyadmin_1.png)
3. In the phpMyAdmin, click on the desired database name you need to take a backup. Click on it from the left side.
![](https://s15.postimg.cc/byloa949n/databsename.png)
4. When all your tables are loaded, now click on “export” option which is located above all the tables.
![](https://s15.postimg.cc/ip25jn1p7/databsename_1.png)
5. Now a screen appeared in front of you where you can select desired tables from the list and the format of the file you wish to save it.
Note: If you wish to select all the tables they choose “Quick - display only the minimal options” and from this option “custom - display all possible options” you can select the desired tables you wish to take backup.
![](https://s15.postimg.cc/9h9x2x7hn/sql.png)
6. Now under the format option open the dropdown list and choose “SQL” option, so that you can download the database in SQL format.
![](https://s15.postimg.cc/3t3mc00kb/spqformat.png)
7. After selecting both the option, click on “GO” icon to start the export. Now your download will start automatically.
![](https://s15.postimg.cc/m8o39dc3v/sql_1.png)
That's it !!