OpenCart has a Backup/Restore system for your store's database.
- Log in to the OpenCart administration panel
- Go to System >> Maintenance >> Backup
- Select the option you want from the Backup or Restore tabs
- To make a backup, select the desired tables and click Export
- Save the .sql file to your computer
- If you want to restore, click on the Restore tab then click on Import - select the saved sql file of your database and click on Import.
