Reusing old databases

[the_darkhorse]

I had a store using version 1.3.8. I am now building a new store with version 1.3.9. Could somebody please explain if and how I can use my database from the old store in my new store so I can keep my customers details and order details. I have been searching all afternoon and my head is spinning. Thank you.

[frank18]

Your best bet is to upgrade the old 138 store to 139. Within the docs you will find the instructions on how to upgrade your old database to the 139 patch.

[the_darkhorse]

The old store was deleted because it got hacked pretty bad

[DrByte]

As frank18 said, in the upgrade instructions you'll see information about upgrading the database to work with the current version. In your case, start with v1.3.9 PHP files, but when you're following the instructions you can jump to the database part.

BUT ... if your old store was hacked badly, you're going to need to go through all your data VERY carefully too, to make sure your configuration settings in your admin are clean, your payment module settings are clean, your category and product descriptions are clean, admin users are clean, etc.

[the_darkhorse]

As frank18 said, in the upgrade instructions you'll see information about upgrading the database to work with the current version. In your case, start with v1.3.9 PHP files, but when you're following the instructions you can jump to the database part.

I don't really understand what you mean by that. I don't have any of the files from the old store anymore. All I have is the database. I have done a new install of 1.3.9 and I just want to be able to have the old customers and order info. I don't need any other settings.

[DrByte]

You can import your entire old database overtop of your new database.
Then run zc_install and choose Database Upgrade to bring its structure up to v1.3.9

That's all part of the upgrade instructions mentioned above, and brings *everything* forward from your old database.

Then go and cleanup all the data, as I mentioned.


Any other approach such as bringing over only selected data is not as straightforward, and is not recommended unless you have strong knowledge of how all the database tables work together.

[the_darkhorse]

I hope you don't mind me asking how I would import the old database over the new one? I don't have much database experience.

[the_darkhorse]

I have tried importing the old database over the new one in myphpadmin. When I go to the installer to do the database upgrade there is no option to do that. Only options are "install" or "upgrade cfg files". I am really lost now. I hope 7 years of customers and orders aren't down the drain.

When I go to my store now i get this message

1146 Table 'cuddlesn_abbygro.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

[DrByte]

Again, in the upgrade instructions it tells you in more detail how to do it, including mentioning the need to use the same DB_PREFIX setting in your new store as you had in your old store.

When you look in phpMyAdmin, you'll see all your table names listed. If they all start with some common prefix like "store_" or "zen_" or "dark_" or whatever, then that's what you need to put in your DB_PREFIX setting in both of your configure.php files.
If you don't make it match, then Zen Cart won't know which tables to look in.

[the_darkhorse]

Hi Dr Bytes. All fixed thank you very much. I forgot about the zen_ prefix in the old database. Very easy to sort out once I changed that. Thank you very much for the assistance. Very much appreciated.