Backing Up Your OpenCart Database

OpenCart allows you to create and restore backups of your store database with just a few clicks.

Backing up is one of the most important things you can do for your website it's your saftey net incase things go wrong.

In order to create a backup of your store's database you need to log in your OpenCart admin area.

Go to System » Backup/Restore

backup menu

In the "Backup" box you can see all the tables of your store's database. Click "Select All" to add them to the backup.

select tables

Then click the "Backup" button on the upper right corner of the page.

start backup

This will create a backup of the database and let you download it to your computer for safe keeping.

save backup

Now you have a backup of your database's current state which you can restore later.

In order to restore a backup you made previously from the OpenCart admin, click on the browse button to select the backup.sql file from your computer.


Now click the "Restore" button on the upper right corner of the page.

restore backup

This will overwrite your store's current data with the backup copy you selected.

It is advisable to take regular backups of your database and keep them in a safe place. Believe me you never know when your going to need them.




Leave your comments

Post comment as a guest

0 / 300 Character restriction
Your text should be in between 10-300 characters
terms and condition.
  • No comments found

Get The Latest Browsers



News Letter

Sign up for news letter