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.

View all posts