msgbartop
Gossimer’s Premier Web Hosting and Domain Registration Knowledgebase.
msgbarbottom

16 Jul 10 How do I restore a MySQL database?

Restoring your Database via phpMyAdmin

Restoring your database is as easy as backing it up. If you would like to rewrite the backup over an existing database, follow the process listed below:

1. Connect to your database using phpMyAdmin. Click here to read how >>

2. Click on the database name in the database list on the left, click all the check boxes next to the table names and select Drop in the With selected: drop down box.
 

dbbackup3 How do I restore a MySQL database?

 

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.

 

Restoring your MySQL Database from within the Control Panel

You can restore a MYSQL database from within the Gossimer Hosting Control Panel. Please follow the steps explained below:

1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package. Click here to know how >>

2. In the search results view, click on the domain name. This will take you to the order details view.

3. Click on Manage Web Hosting Service in the lower toolbar.

4. In the Website Management interface pop-up that follows, go to Manage Website -> Database Manager -> Backup/Restore Database.

5. Select the radio button Restore Database.

6. Select the database from the dropdown menu next to Select Database.

7. Specify the exact location and filename of the backup file in the You can select the backup which was saved on the server in a

8. Click on Submit to restore the database.

Tags: , , , , , , , , , , , , , , , , , , , ,