When you use cpanel web hosting many time you need to backup your MySQL database, today i show you how to import and export mysql database from your cpanel phpmyadmin

backup MySQL database, manually from cPanel phpmyadmin

1. first go to your cpanel and login

2. go database tab & select phpmyadmin

3. now follow right sidebar on phpmyadmin, showing database name.

4. choose what database you want the backup, and click.

5. now follow top bar and find an option “Export”. click the export button.

6. now showing “Export method:”

7. click “Quick – display only the minimal options” button

8. select “Format: SQL option”

9. now click on the “Go” button

10. now save the file in your computer

now complete your MySQL database, manually backup on your computer