How to Backup/Export or Restore/Import Your Joomla Database Tables
Disclaimer: Your support helps keep JovialGuide running! Our content is reader-supported. This means if you click on some of our links, we may earn a commission.
Having a backup copy of your Joomla database tables is a great measure to protect your Joomla website in case anything happens.
Databases are used for storing information. Your Joomla database tables contain all of your published, unpublished, drafted articles, all of your website configuration settings, etc.
Backing up your Joomla database tables will help you restore it at anytime without any thought of loosing your website.
This JovialGuide will show you how to easily export/backup and restore all of your Joomla database tables.
Why You Should Backup Your Joomla Database Tables
Anyone that do not know what it means to backup a database table would feel less concerned and would say it isn’t necessary to make a backup!
To backup the tables of a database means to make a reserved or standby copy of the database tables. Having a reserved copy of your Joomla database tables will help you easily restore your Joomla website anytime any day.
You already know that whenever an unauthorized access is gained into your Joomla website, such access can destroy your website. Imagine if you didn’t make any backup before it got penetrated, everything’s gone!
If you want to move your Joomla website from your current hosting provider to another Joomla hosting provider without loosing your well written and optimized articles, etc. How do you want to move them (all of your articles, comments, etc.,) to another Joomla hosting provider without having a copy of your Joomla database tables? That’s totally impossble! You’ll have to have a copy of your Joomla database tables that contains all of your articles, comments, etc.
Since all of the settings, articles, categories, etc., are stored in your Joomla database tables, it’s absolutely necessary to make a backup of your Joomla database for either security reasons or for anyother reason.
Backing up of a database is usually done by web hosting providers. If your Joomla hosting provider often do not make backups of your Joomla database tables, you have to quickly do it right now to avoid heart touching stories!
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 can easily restore.
If you wouldn’t like to loose your Joomla website, then you have to backup your Joomla database tables.
Here are some of the reasons you should backup your Joomla database tables:
- For safty
- To be able to move to another Joomla hosting company
Where to Find Your Joomla Database
How to Backup/Export, Restore/Import Your Joomla Database Tables
The following sub-sections of this post will show you how to backup and import your Joomla database tables.
How to Backup/Export Joomla Database Tables
Before you can backup your Joomla database tables, you must have access to the cPanel (control panel) of your Joomla web hosting account. Your Joomla database is located right inside PhpMyAdmin. phpMyAdmin is located inside the cPanel (control panel) of your Joomla web hosting account.
To backup your Joomla database tables, log in to the cPanel of your Joomla web hosting account.
Under the database section, click on PhpMyAdmin.
You’ll be taken to PhpMyAdmin. PhpMyAdmin is a database administration tool that contains all of your databases.
Click on the database your Joomla website is using and all of the tables present in your Joomla database will be displayed.
In this JovialGuide, our Joomla database name is joomla.
If you don’t know the name of the database your Joomla website is using, see how to find out the name of database your Joomla website is using.
Now that you’ve found out the name of database your Joomla website is using, let’s proceed.
Click on export and you will be taken to another page that lets you enter your export method and format. The export method has two options, they are;
- Quick – displays only the minimal options
- Custom – displays all possible options
The quick method enables you export all of the tables in your Joomla database without customizing how it should be exported. If you choose the quick export method, you’ll be able to quickly export all of your Joomla database tables without entering the advanced settings.
The custom export method lets you customize 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.
If you think you don’t have enough time to customize the setup for the tables you are exporting, go for the quick export method. However, if you have enough time, go for the custom export method.
The export format is the type or extension you’d like it to be. Many formats/extension types are listed there.
Select SQL as the format and click go. Your Joomla database tables will be downloaded into your local storage in .sql format, example; joomla.sql.
If you’d like to export your Joomla database tables into a different format, you can select it from the list of export formats.
You can also access your Joomla database by clicking on database (at the top of PhpMyAdmin). All of the databases in your PhpMyAdmin will be displayed.
Now that you’ve learned how to backup/export your Joomla database tables, let’s learn how they could be used/imported.
Restoring/Importing Joomla Database Tables
You can easily restore/import all of your Joomla database tables if you are moving to a new Joomla web host or your Joomla database got attacked and all of the tables in your Joomla database got deleted.
To import your Joomla database tables, log in to the Control Panel (cPanel) of your Joomla web hosting account. Under the database section, click on PhpMyAdmin.
You’ll be taken to PhpMyAdmin, there, you’ll see all of the databases present in your PhpMyAdmin.
Since we are restoring our Joomla database tables, we’ll be using import not export this time.
Click on import.
Upload the .sql file you exported/downloaded into your storage earlier (if the file you exported is not in .sql format, upload it), enter other required settings and click ok.
You have successfully exported and imported your Joomla database tables.
If someone deletes your Joomla database tables, you can easily restore all of them by importing.
Before you can restore or import the backup of your Joomla database tables, you have to make a backup first.
See other of our Joomla tutorials.