LexiConn Knowledgebase

Knowledgebase Home | Favorites Knowledgebase Home | Favorites
Search the Knowledgebase Browse by Category
How do I backup my MySQL database?
Article Details

Last Updated
17th of June, 2008

User Opinions (11 votes)
81% thumbs up 18% thumbs down

How would you rate this answer?
Helpful
Not helpful

The easiest way to backup your MySQL database is through phpMyAdmin, the web based mysql administration tool available through the Account Manager. The steps to backup your database via phpmyadmin are shown below

1. Login to phpmyadmin with your database username and password. Then choose your database from the menu on the left. You should see a menu header for your database that looks like:

phpmyadmin_export

2. You can select the checkboxes for "Structure" and "Data" to backup both the table structure and data in each table.

3. Click on the checkbox "Save as file" and you can optionally zip up the sql backup file under "Compression". This will download the backup file to your computer.



Restoring your Database via phpMyAdmin

Restoring your database is as easy as backing it up. If you'd like to rewrite the backup over an existing database, click on the database name in the database list on the left, click all the boxes next to the table names and select Drop in the With selected: drop down box.

Restoring your database is as easy as backing it up. If you'd like to rewrite the backup over an existing database, click on the database name in the database list on the left, click all the boxes next to the table names and select Drop in the With selected: drop down box.

phpmyadmin__run_query

This will drop all existing tables in the database. Then head over to the top menu bar and click on SQL. This will bring up a window where you can either type in SQL commands, or upload your SQL file. The window should look like this:

phpmyadmin_restore

Click on the Browse button, and select the sql backup file you wish to upload to the server. Once you've selected the file, click on 'Go'. This will upload the backup file to the server and execute the SQL commands in the backup file for your database.


Related Articles
Attachments
No attachments were found.

Powered by Interspire Knowledge Manager Knowledgebase Software