Happy Year! Guest
[ Login ]
6 Jan, 2009
Home | Customer Centre | Support Centre
RSS | Set Homepage | Favorite
Search:
Browse:

How do I export or backup a MySQL Database

Date Created: 12 Oct, 2008   (4 month(s) ago) Viewed: 144 Rating: 

Overview

How do I export or backup a MySQL Database
Click to Enlarge
How do I export or backup a MySQL Database
You can easily create a database dump (export/backup) of a databases used by phpMyAdmin.

This tutorial will outline the steps required to export or backup your MySQL databases.
Attention
  • phpMyAdmin may not handle large databases.
  • You have NOT backed up the files and folders via phpMyAdmin, such as images.
The above information is for reference only

Guide

In order to do so you should access the phpMyAdmin interface available in your account.

Click to Enlarge

You will be brought through a redirect screen stating that the phpMyAdmin tool will be loaded shortly then the new page will be automatically loaded in your browser.

Once the phpMyAdmin tool loads, you can select the database that you would like to backup from the drop-down menu called Database (located in the upper left corner of your web browser).

Click to Enlarge

A new page will be loaded in phpMyAdmin for the database selected from the drop-down menu. In order to proceed with the backup click on the [Export]

Click to Enlarge

The options that is advisable to select apart from the default ones are Save as file (which will save the file locally to your computer in a .sql format) and Add DROP TABLE (which will add the drop if table already exists statement in the database backup).

Click to Enlarge

This is all that needs to be done and you can click the [Go] button to start the export/backup of your database.

Click to Enlarge

A download window will popup prompting for the exact place where you would like to save the file on your local computer or automatically start the download depending on your local settings.

Click to Enlarge
Was this article helpful?
You can bookmark it with your tracker:DiggredditDeliciousGoogle BookmarksWindows LiveFacebookSlashdot BookmarksPropellerTechnoratiBlinkListYahoo bookmarksMa.gnoliaSquidoo
Permalink:  
 
ec2Biz.com Interactive Multimedia Ecommerce Online Shop Solutions
©2009 Focus Network Company. All Rights Reserved.