OpenCart 1.5 conveniently provides the ability to backup or restore database files within its interface.  The following tutorial will guide you in using these options.

How to Backup or Restore your OpenCart 1.5 database files

  1. Login to the Administration Dashboard as an Administrator
  2. Hover over the menu bar where it says SYSTEM and then click on BACKUP/RESTORE at the bottom of the drop-down menu


  3. Select the database tables that you wish to backup, then click on BACKUP
  4. After selecting BACKUP, you will see the prompt asking you to save the file.  Make sure that you save it somewhere that you can find it again.  Once you have saved the file, you can rename to something more meaningful, such as:  backup10-11-2012. 


    Select RESTORE, then select the Browse button to identify the file that you trying to restore.
  5. If you intend to keep multiple copies, please rename the backup file (backup.sql) to another name that will allow you to identify the file. 

The Backup and Restore feature built into the OpenCart 1.5 is a great feature, but I recommend making use of full site-backups if it all possible.

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Did you find this article helpful?


n/a Points
2014-11-11 11:56 am

Hi! When I tried to import and restore a backup all I got was an error mesage that it couldn t find one of the tables. The table however was there along with all of its data and I could see it when I opened the sql file. I could  also see that the table exists on my host database and I can t figure out what s wrong. Do you have any suggestions? Thanks in advance

2,342 Points
2014-11-11 6:51 pm
This may be an issue within the OpenCart extension. Try importing your SQL file using PHPMyAdmin.
n/a Points
2015-04-10 5:15 pm

Thanks for posting this  article. Although i found this orogram to be more easier, to backup and restore database. They have detailed documentation for this question:

I hope this might help somebody.


Post a Comment

Email Address:
Phone Number:

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Need More Help?

Help Center Search

Current Customers

Email: Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.