How to Create a Backup of a Database using PHPMyAdmin

Backing up your database regularly is a good idea and should be done. This guide will walk you through the process and help you create a backup (dump) of your database using phpMyAdmin. To do this, you will need to be logged in to the GreenGeeks cPanel and click on the phpMyAdmin icon.

Select the database you wish to backup in the drop-down database selection box on the left
Click the Export Tab towards the top of the interface. This will take you to the Export page with a lot of options
Click “Select All”. This ensures that all the tables in the database is included.
Select “SQL” in the Export box
Ensure that “Structure” is selected, then make sure the “Add Auto_Increment” and “Enclose Table and Field Name with Backquotes” boxes are ticked.
Make sure “Data is selected, check “Hexadecimal for Binary Field” and set the Export type to “Insert”.
Select “Save as File” then click “Go”. You will be prompted to save the database to your computer.

That’s all there is to it.

Comments are closed.

Basic Helpful Tutorials (43)
Cpanel (14)
Domain name (40)
Email (54)
FTP (9)
General FAQ (62)
Home Page (14)
Mysql (7)
Our Reseller Program Tutorials (4)
Pre Sales (25)
Reseller Hosting (5)
Script installations (7)
SSL (24)
TBR (8)
Video Tutorials (7)
Website Builders (29)
Windows Hosting (14)

WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better. is an
ICANN Accredited Registrar

ICANN Certified Registrar is an Authority (CIRA)
certified .CA Domain Name Registrar is an Authority (CIRA) certified .CA Domain Name Registrar
Click for the BBB Business Review of this Internet Services in Ottawa ON

HACKER SAFE certified sites prevent over 99.9% of hacker crime.
  • Facebook
  • Twitter