Post by dgenx316 » Sun Sep 20, 2015 2:48 am

So my store got messed up, and I've reuploaded all my store files from a zip. However i'm trying to restore my database which was messed up as well, but when I try to import, I get the following:
SQL query:

TRUNCATE TABLE `address` ;

MySQL said: Documentation

#1146 - Table '2015-09-15_15-43-58_backup.address' doesn't exist



Thu Feb 27, 2014 10:12 pm

Post by deepvision » Sun Sep 20, 2015 12:38 pm

The backup assumes that the tables are there and fails to continue if they are not.
In order for the backup to succeed you should run an installation script so that it creates the database tables.
You can just copy a fresh installation of opencart (same version you have now) into a new folder and run it from there.
Just make sure to specify the empty database prefix. Once it completes you will be able to restore your database from the backup. And then you can remove the folder with the opencart install.


User avatar
Active Member


Tue May 19, 2015 1:03 am
Who is online

Users browsing this forum: No registered users and 6 guests