Having a backup or export copy of your database tables is a great measure to protect the database tables of your Joomla website in a case that your website gets hacked.
Databases are used for storing information. Your Joomla database contains all of your published, unpublished and drafted articles, all of your website configuration settings, etc.
This JovialGuide will show you how to easily export/backup and restore all of your database tables.
Backing up your Joomla database tables helps you restore it at anytime without any thought of loosing them.
Table of Contents
Why Should I Backup my Joomla Database Tables? Is that Necessary?!
Certainly, millions of thoughts are running right in your mind including why you should backup or export your Joomla database table.
Imagine, to loose something that took you ages to build in a blink of an eye without having a duplicate copy of it, which you could easily restore. If you wouldn’t like to loose your followers, then you have to backup your Joomla database.
But wait! What Does it Mean to Backup a Database table?
Anyone that doesn’t know what it means to backup or export a database table would feel less concerned and would say it isn’t necessary to make a backup of my database tables.
To backup the tables of a database means to make a reserved or stanby copy of a database table. Having a reserved copy of your database tables would help you easily restore your Joomla website.
We already know that whenever an unauthorized access is gained into our website, it only comes to steal and destroy. Imagine if you didn’t make any backup before it got penetrated. Hey, you’ve lost everything!
Imagine, you want to move your Joomla website from your current hosting provider to another hosting provider without loosing your well written and optimized articles for SEO. How do you want to move all of your articles, comments, etc to another webhost without having a copy of your database tables? That’s totally impossble! You’ll have to have a copy of your database tables that contains all of your articles, comments, etc.
Since all of the settings, articles, categories, etc are stored in your database, it’s absolutely necessary to make a backup of your database for either security reasons or for anyother reason.
Backing up a database is usually done by your hosting provider. If your hosting provider hasn’t made any backup of your database, you have to quickly do it right now to avoid heart touching stories.
Where is my Database Located?
Your database is located right inside PhpMyAdmin of the cPanel of your webhosting account.
Backing up/Exporting Joomla Database Tables
Before you can backup your Joomla database tables, you must have access to the cPanel (control panel) of your web hosting account. Your Joomla database is located right inside PhpMyAdmin, PhpMyAdmin is located inside the cPanel (control panel) of your webhosting account.
Login to your web hosting account. Under database section, click on PhpMyAdmin.
You’ll be taken to a screen that contains all of the databases present in your PhpMyAdmin. Find and click on the database your Joomla website is using.
In this JovialGuide, my database name is joomla.
Don’t know the name of the database your Joomla website is using? See
Now that you’ve found out the name of the database your Joomla website is using, let’s proceed.
On the the left sidebar of PhpMyAdmin, you’ll find your Joomla database name, click on it and all of the tables present in your Joomla database will display.
Click on export and you will be taken to another screen that asks you to enter your export method and format. The export method has two options.
- Quick – display only the minimal options
- Custom – display all possible options
Quick method enables you export all of the tables in your Joomla database without customising how it should be exported. If you choose the quick export method, you’ll be able to quickly export all of your tables without entering the advanced settings.
And the custom export method lets you customise or setup the advanced settings for the tables you are exporting. If you choose the custom method, you’ll be able to enter advanced settings for the tables to be exported.
Which Should I Choose? Quick over Custom?
It depends on you. If you think you don’t have enough time to customise the tables you are exporting, go for the quick method. What if you have time and you want to customise it? Go for the custom method. It actually depends on you.
The export format is the type or extension. Many format/extension types are listed there.
Select SQL as the format and click go. Your database tables will be downloaded into your local storage in .sql format, example; joomla.sql.
You can also access your Joomla database by clicking database at the top bar of PhpMyAdmin. All of the databases in your PhpMyAdmin will be displayed.
Now that you’ve learned to backup Joomla database tables, let’s learn how tables could be imported or restored after being exported.
WordPress users looking for the best WordPress web hosting provider in 2019, see top 10 best WordPress web hosting service providers in 2019
If you are looking for the best Joomla web hosting provider in 2019, we wrote a JovialGuide that shows you the top 10 best web hosting companies that offer Joomla hosting in 2019. These top 10 best Joomla web hosting service providers in 2019 offer quality Joomla website hosting services.
Magento users aren’t left behind! We also wrote a JovialGuide that lists out the top 10 best Magento web hosting companies in 2019.
Restoring or Importing Joomla Database Tables
You could easily restore or import all of your tables if you are moving to a new web host or your database got attacked and all of the tables in your Joomla database got dropped (deleted).
Login again to the Control Panel (cPanel) of your webhosting account. Under the database section, click on PhpMyAdmin.
You’ll be taken again to PhpMyAdmin, there, you’ll see all of the databases in your PhpMyAdmin.
Since we are restoring/importing our tables, we’ll be using import not export this time.
Click on import.
And enter the .sql file you exported ealier, enter other required settings and click ok.
Do well to open your Joomla database before before you click export else you’ll export all of the databases in your PhpMyAdmin instead of the tables in your Joomla database.
- how to setup, install and run Joomla locally on android (step by step tutorial with pictures)
- the beginners guide: the overview of the control/administrative panel of Joomla (step by step tutorial with pictures)
- how to perfectly learn/practice Joomla very fast for free (step by step tutorial)
If someone accesses your PhpMyAdmin without permission, and drops (deletes) all of the tables in the database of your Joomla website. You could easily restore all of them by importing them.
Before you can restore or import the backup copy of your database, you have to make a backup copy of your database tables. This JovialGuide has shown you how to export and import your database tables.
If you encounter any problem, please leave a comment in the comments section.