How to restore a Joomla backup made with phpMyAdmin Print

This tutorial will show you how to restore a Joomla database backup previously made with phpMyAdmin

First, let's create a new database to store the data that's currently in the Joomla database, just in case there's a problem restoring the backup

1) Scroll down until you see Databases

2) Click MySQL Databases

 

3) Type a name for your backup database, then click Create Database

 

4) Now go to Home

 

5) Scroll down to Databases again

 

6) Go to phpMyAdmin

 

7) Click on the Joomla database

8) Click Operations

 

9) Under Copy database to, type the temporary database name

10) Uncheck CREATE DATABASE before copying

 

11) Click Switch to copied database

 

12) Then, click Go

 

The database seems to have copied successfuly. Now, let's restore the backup

13) Select the original database

14) After scrolling down to the bottom of the page, click Check All

 

15) Then, choose Empty from the drop-down box

16) Click Yes

 

 

Now that the database is empty, we can restore our backup

 

17) Click Import

 

18) Browse for and select the backup file

 

Scroll down

 

19) Click Go

 

 

If you encounter any problems, the temporary backup database we created should come in handy