Login to cPanel ==> Databases ==> Click on phpMyadmin



1 – Open phpMyAdmin

2 – Click on Export

3 – Under Export – Select the database you want to backup

4 – Select SQL

5 – Select Structure, Add DROP TABLE, Add IF NO EXISTS, Add AUTO_INCREMENT VALUE and Enclose table and field names with backquotes.

6 – Select Data, Complete inserts, Extended inserts and Use hexadecimal for binary fields.

7 – Select Save as file your data base. Here you can use any name you want.

9 – In Compression specify your choice.

10 – Click Go.



Vishwajit Kale

Vishwajit Kale blazed onto the digital marketing scene back in 2015 and is the digital marketing strategist of Hostdens, a company that aims to provide reliable web hosting solutions. Vishwajit is experienced in digital and content marketing along with SEO. He's fond of writing technology blogs, traveling and reading.