How do I backup my Joomla database with phpMyAdmin?

Text Version

In this tutorial we will be creating a backup of our Joomla database using phpMyAdmin.
phpMyAdmin is the most widely used database administration tool so that is why we have chosen it for this tutorial.
You will have to login to phpMyAdmin through your hosting service.

In this tutorial we will be creating a backup of our Mambo database using phpMyAdmin.
phpMyAdmin is the most widely used database administration tool so that is why we have chosen it for this tutorial.
You will have to login to phpMyAdmin through your hosting service.

From the Database dropdown menu select your Joomla database.

From the Database dropdown menu select your Joomla database.

Now we need to click on the Export tab.

Now we need to click on the Export tab.

By default, every table will get exported. If you would like to export only selected ones, you may choose from this list.
You can also change the output options for the file, and what types of data you want to save. Don't change these options unless you know what you are doing.

By default, every table will get exported. If you would like to export only selected ones, you may choose from this list.
You can also change the output options for the file, and what types of data you want to save. Don't change these options unless you know what you are doing.

There are 2 ways to get the output. You can get it directly on your screen so you can copy it. Or you can save it to a file automatically. That is what we will do.

There are 2 ways to get the output. You can get it directly on your screen so you can copy it. Or you can save it to a file automatically. That is what we will do.

Click the Go button to generate the file

Click the Go button to generate the file

We want to save the file, so just click OK.

We want to save the file, so just click OK.

You will receive a notification when the download is complete. That concludes this tutorial.

You will receive a notification when the download is complete. That concludes this tutorial.

  • 17 Users Found This Useful
Was this answer helpful?

Related Articles

How do I add a separator menu item?

Text Version In this tutorial we will be creating a new separator menu item. Begin by...

Sessions table error

DB function failed with error number 1016 Can't open file: 'jos_session.MYI'....

How do I get into a locked article?

It's happened to just about everyone at some point. You're going though, editing articles, and...

How do I get rid of "Welcome to the Frontpage"?

Have you ever wondered how to get rid of the "Welcome to the Frontpage" title from your Joomla...

How do I add content?

Text Version In this tutorial we will be adding a content item to the site. Begin by...