Backup and Restore Databases in OpenCart

By on February 2nd, 2016

OpenCart is one of the most popular as well as a powerful eCommerce platform. It is a self-hosted system that you can run on your own server. It provides all the features we need to manage our store including some features that might help developers working on your store.

One such option they provide in the admin panel is Backup and Restore. It means that you can create a backup of your database, or restore a backup of your database directly from the admin panel.

In this tutorial, I will show you How to backup and restore the database in OpenCart. It is a very easy process and it might take less than a minute to create a backup of your store. It is always a good thing to create regular backups of the database because in case of disaster, backups are the savior. So, Let’s get started with the tutorial.

Backup and Restore Database in OpenCart

To create a backup or restore it, log in to the admin panel of your store and click on the System -> Maintenance -> Backup / Restore option from the left sidebar. See the following screenshot for reference.

Backup and Restore in OpenCart - Step 1

On this page, you will see a page with two tabs. One for backup and one for restore. Backup is loaded by default when you click on this option. So, Let’s first see how to create a backup, and then we will see how to restore it.

Create database backup in OpenCart

The backup screen is easy or you can say self-explanatory. It contains a list of tables you have in your database. To create a new backup, select the tables you want to back up and click on the Export button given at the bottom of the page.

If you want to create a backup of all the database, select all the tables (Selected by default) and then click on the Export button to download an .sql file of your database.

Create Database backup in OpenCart

Restore database backup in OpenCart

To restore a database backup, click on the Restore tab. In that tab, you will see a blue button with the Import text. Click on it to select the SQL file from your computer.

That’s all you have to do to restore a backup of your database into your OpenCart store. Once the import is successful, you will see a success message just like the following image.

Restore a database backup in OpenCart


So, this is how you can backup and restore the database of your OpenCart store directly from the admin panel. Creating a backup of the database just takes two to three clicks in OpenCart. And it is very important to take regular backups of your database.

If you have any questions regarding backup and restore in OpenCart, please let us know in the comment section given below. We are happy to help!

Leave a Reply