Steps to backup and restore database tables and data of your Joomla website
I learned from experience that DB backup is most important aspect while running your business. There are different reasons why backups should be taken time to time depending on your business model. The emergency and need for good backup can arise can arrive any time. Malicious attackers hacked my Joomla site by bypassing the best security Joomla and web host provides. That is when I needed to restore previous good DB backup to revert the site back to a previous working state.
This article will provide detailed steps to take DB backup from your web host to local drive on your desktop/laptop. Also it will provide details on how to restore the DB backup from your desktop/laptop to your web host when required.
Steps to take DB tables backup from your site to local drive-
1. Login to your site Cpanel
2. Look out for ‘phpMyAdmin’ and click it
3. It will take you to admin screen with your DB name displayed on left panel-
4. Click on the database name and then Click on Export tab on the right panel.
5. It will show message as “Exporting tables from DATABASE_NAME database”.
6. Click Go and it will prompt for path where to save the extract tables and its data. It will be saved on your desktop in local drive.
Steps to restore DB tables and data backup from your local drive to your site MySQL-
1. Login to your site Cpanel
2. Look out for ‘phpMyAdmin’ and click it
3. It will take you to admin screen with your DB name displayed on left panel-
4. Take backup of existing DB.
5. Delete all the existing tables by selecting all of them and then dropping as shown in below-
6. Click on Import tab on the right panel-
7. Browse to SQL script and click Go. It will create all the tables with data.