A Web.com Partner

Restore a Joomla backup using phpMyAdmin

This tutorial will show you how to restore a Joomla backup using 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

frame03_1118

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

frame05_1110

4) Now go to Home

frame07_1103

5) Scroll down to Databases again

6) Go to phpMyAdmin

frame08_194

7) Click on the Joomla database

frame09_188

8) Click Operations

frame10_180

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

frame12_172

10) Uncheck CREATE DATABASE before copying

frame13_156

11) Click Switch to copied database

frame14_162

12) Then, click Go

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

frame15_144

13) Select the original database

frame16_151

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

frame18_136

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

frame19_145

16) Click Yes

frame20_136

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

17) Click Import

frame22_136

18) Browse for and select the backup file

frame23_129

Scroll down

19) Click Go

frame25_126

If you encounter any problems, the temporary backup database we created should come in handy19) Click Go

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

x