How to Restore SQL Backup

Many websites use databases to store and access information. One of the most popular languages for web databases is called "SQL," short for Structured Query Language. A similar language is called "MySQL." When important website information needs to be saved, it is backed up to a safe location. This backup can then be restored when needed. You can easily restore a saved MySQL database backup using the phpMyAdmin tool, which is included with many web hosts.

Difficulty: Moderate

Instructions

Things You'll Need:

• Web host access PhpMyAdmin

1. Log in to your web hosting CPanel or equivalent. This will vary depending on your host. A common example is http://www.yoursite.com/cpanel. If you do not have these details, you will need to contact your web hosting provider.

2. 
    

   On your hosting CPanel, find the section labeled "Databases." Click the icon marked "phpMyAdmin."

3. 
    

   Select the name of the database you wish to restore from the list of databases on the left side of the phpMyAdmin screen. In this example, the database is named "_test."

4. 
    

   Select the option marked "Import" that is above the details of your database.

5. 
    

   On the import page, press the "Browse" button, and locate the SQL backup file from which you will be restoring. Compression will be automatically detected. Once the backup file is selected, press "Go." The backup may take some time to import successfully.

Tips & Warnings

• Exact details will vary depending on the hosting system you use; however, the procedure is the same. Contact your hosting provider with questions on how your system works.
• Restoring an SQL backup is only effective if the data are saved frequently. Remember to back up your important databases often.

References

• MySQL Information
• PhpMyAdmin Details