20 May, 2018
Welcome! Guest
[ Login ]
Home | Customer Centre | Support Centre
RSS | Set Homepage | Favorite
Search:
Browse:

MySQL - How do I export or backup a MySQL Database

Date Created: 12 Oct, 2008   (9 year(s) ago) Viewed: 1339 Rating: 

Overview

MySQL - How do I export or backup a MySQL Database
Click to Enlarge
MySQL - 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.
  • Please note that the database name, username and passwords are case sensitive.
Related Links
*** The above information is for reference only, Please seek independent technical advice if found necessary.

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 Web Hosting Online Shop Domain name Solutions
©2018 Focus Network Company. All Rights Reserved.