Error Restoring Backup

Hi,
I freshly installed OC 1.5.5.1 on my site and my previous version was also 1.5.5.1.

I had backup of the store data by the in-built feature in OC.
now when I try to restore my data I get an error :\

While it could have stumbled over the OC_ prefix (present, absent), is "oc_storeaddress" supposed to be an entire table, of what? One run of installer might have been told to use a prefix, and the next run not told not to use one, so that bringing in the former's backup might have stopped over the difference. Messages of that sort, among that and a few other error codes, are not specific to 1.5.5.1 and often relate to mysql version differences or other causes of slight differences in file syntax, but it did not make that objection. There is a free "improved backup" extension (a single .xml file) by rph that you might try, in both installations for the purpose, if your original copy of OC is still running and accessible.

butte wrote:While it could have stumbled over the OC_ prefix (present, absent), is "oc_storeaddress" supposed to be an entire table, of what? One run of installer might have been told to use a prefix, and the next run not told not to use one, so that bringing in the former's backup might have stopped over the difference. Messages of that sort, among that and a few other error codes, are not specific to 1.5.5.1 and often relate to mysql version differences or other causes of slight differences in file syntax, but it did not make that objection. There is a free "improved backup" extension (a single .xml file) by rph that you might try, in both installations for the purpose, if your original copy of OC is still running and accessible.

Please give the link for free improved backup extention

This thread: http://forum.opencart.com/viewtopic.php ... 2&p=399522
This post, by rph, has the file link: http://forum.opencart.com/viewtopic.php ... 22#p401314

Had to relocate it, otherwise I'd have given it above.

butte wrote:This thread: http://forum.opencart.com/viewtopic.php ... 2&p=399522
This post, by rph, has the file link: http://forum.opencart.com/viewtopic.php ... 22#p401314

Had to relocate it, otherwise I'd have given it above.

Still same error, after installing that vqmod xml.

(1) If you can still do it, install the .xml into the (original) source store as well as into the (successor) target store, make a new backup, and restore that backup, so that both are using the exact same method's file (with rph's .xml in place in both stores).

(2) Try bringing up the backup.sql (or the whatever_it_is_named.sql) in a text editor and searching for
oc_storeaddress
to see whether the table itself actually is or is not missing in the first place.

Then if it actually is there, look at it carefully to see whether it appears as
Table 'mgestoredb.oc_storeaddress' with a pair backtics (not single-quotes)
or instead as
Table 'mgestoredb.oc_storeaddress' with instead a pair of tics (single-quotes, not backtics)
because the difference may be a minor difference in syntax according to the method of making the backup, and that would interfere.

aviralgoel wrote:I had backup of the store data by the in-built feature in OC.

If you still have the database, make a backup by exporting it in phpMyAdmin...

Yes, do first what GoGo OpenCart suggests, that is the preferred way. Use phpMyAdmin Export, then use phpMyAdmin Import.

You originally did it "by the in-built feature in OC" -- and you do not want to mix those methods and their files, they have the same data but different syntax.

butte wrote:then use phpMyAdmin Import.

Yeap, forgot to mention the Import afterwards, also in phpMyAdmin, thanks for mentioning it...

That's okay, I forgot to divert him to phpMyAdmin, it seemed that he might have been too far into the lurch to do it.