Importing Database into new Installation

heavenlynights:

... wondering ... if i can import a database which is for zen version 1.3.7.1 into a database for a fresh install of zen version 1.3.8a?

If this is possible, I am guessing that i would have to re-upload the zc_install directory for version 1.3.8a and then run the install and choose update database.

Could someone please be kind enough to either confirm my thoughs or correct me if I am wrong.Yes, that is correct.

Thanks Doc for confirmation

Can I open this again?

I have setup and installed 1.3.8a on a new server, and followed the procedure above by deleting the database of the clean install, creating a new one of the same name, and importing a database from an old install on another server - the old version being, I think, 1.3.6.

So I run the installer and get to the point where I can run 'upgrade database'. When I do so, I get this:

in:
[select admin_id, admin_name, admin_pass from admin where admin_name = 'my zc_admin username']

I have the same admin user in the old database as in the new setup.

The upgrade does not proceed, so far as I can tell. I have run the fix_cache_key.

What am I missing?

If you're going to move from one server to another, be sure you're using the SAME version of Zen Cart on both sides.

If you need to do an upgrade, do that AFTER you've got the OLD version working perfectly on the new server first.

https://www.zen-cart.com/tutorials/index.php?article=100

That would be a difficult one for me, as I'm moving the site to a server which runs PHP/mySQL5. On which zencart 1.3.6 won't run?

Well, you could do the whole upgrade on the old server first, and then do the move afterwards.

The only big caveat for v1.3.6 with respect to PHP 5 is the /includes/functions/sessions.php file which needs a small update for PHP5 compatibility. If I remember correctly, you can use the v1.3.8 version of that file to bridge that gap.

Thing is, my client isn't happy with the idea of the site being down. Path of least resistance, I'm afraid. But if I installed 1.3.6 with the 1.3.8 sessions.pph, is it your feeling I'd get away with it?

I appreciate your assistance. been playing with this one for quite a while.

godt:

Thing is, my client isn't happy with the idea of the site being down.Naturally.
Why are they moving hosts then?

godt:

But if I installed 1.3.6 with the 1.3.8 sessions.pph, is it your feeling I'd get away with it?
That's a bandage only. Intended just for getting rid of PHP5 errors specifically. It doesn't fix the fact that the MySQL 5 support in v1.3.8 is missing in v1.3.6 ... and that v1.3.6 is officially no longer supported.