How to restore a Joomla backup made with phpMyAdmin

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

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to back up your Joomla database using cPanel

Backups are an essential part of any active website. Not making regular backups can be a disaster...

How to back up your Joomla database using phpMyAdmin

Backups are an essential part of any active website. Not making regular backups can be a disaster...

How to change the default Joomla favicon

A favicon is a small image that shows up next to the website's name. Here is the default Joomla...

How to change the Joomla directory using cPanel

This tutorial assumes you are already logged in to your cPanel account 1) Click File Manager...

How to download the latest Joomla version and install it on your server

1) For this tutorial, you will need to open your web browser and go to http://www.joomla.org...