Moving Store Questions

[suntower]

Sorry. Several all over the map questions.

A new client of mine has been testing a Zen Cart 1.3.9f installation for several months on an IIS server which is going away. The owner decided last week to move it to a shared host (GoDaddy) with a pre-installed 1.3.9h.

I have been given access to the folders on the old server and XML files of the individual -tables- but not a single MySQL backup of the entire database... and I can't figure out how to make one remotely. (I tried the Backup addition and it refused to work. Also I can't figure out how to access PHPMyAdmin on their Windows server or the MySQL command prompt.)

There is no transaction history or customers to speak of.

All we want to take with us is:
1. Perhaps 200 products---with images
2. A fairly extensive custom theme
3. PayPal Payflow addition
4. International Shipping addition

So I guess my question is how best to 'migrate' those bits we want to move given that ZC is already installed on the new server---and has a minor version difference.

I read that there are no schema differences between f and h so I figured I could simply import the product tables and copy over the images.

Also, given that it's a minor version difference, I was wondering if I couldn't just copy over the source files which do not exist on the new installation. Or is that asking for trouble?

Sorry if this sounds all fragmented... I kinda need a plan of attack given that I can't do a simply backup/restore.

Any help would be appreciated.

---JC

[joejoejoe]

I just moved three days ago. I had access to all the files/folders/sql that I needed. I had the instructions on what to do. It still drove me crazy.
There is a tutorial:
https://www.zen-cart.com/tutorials/i...hp?article=100

But you need to export the entire sql from the old server. Is there nobody anywhere in the organization that can get in there and run a quick export for you?

You said you've got XML of all the individual tables - if you're 100% sure that these are all the tables from the old db, maybe you can import them one at a time. (I think you can import data to sql db via xml files, but I am only 2mm above the newbie stage, so I may be wrong.)

For the part about bits - just pull it all. If you try and pick/pull you are going to end up with alphabyte soup. Per the tutorial - install ZC on new server, move over every single file you've got from the old folder and overwrite - except for the two configs, import the old sql db, fix the two configure files to point to the right place (I really screwed that one up.) and you're done.

Good Luck.

[suntower]

Well, I was never able to get a complete backup of the old db so I...

1. Deleted the entire new store folder on the new server.

2. FTP'd over a backup of the old store.

3. Altered the configure.php with the proper db settings.

4. I then deleted every row from every table (not DROP---I was worried about key ids getting messed up somehow?)

5. Finally, imported every table one by one from their XML files.

Tedious, but -seems- to work.

Probably there was a MUCH faster way, but one does what one can.

---JC

I just moved three days ago. I had access to all the files/folders/sql that I needed. I had the instructions on what to do. It still drove me crazy.
There is a tutorial:
https://www.zen-cart.com/tutorials/i...hp?article=100

But you need to export the entire sql from the old server. Is there nobody anywhere in the organization that can get in there and run a quick export for you?

You said you've got XML of all the individual tables - if you're 100% sure that these are all the tables from the old db, maybe you can import them one at a time. (I think you can import data to sql db via xml files, but I am only 2mm above the newbie stage, so I may be wrong.)

For the part about bits - just pull it all. If you try and pick/pull you are going to end up with alphabyte soup. Per the tutorial - install ZC on new server, move over every single file you've got from the old folder and overwrite - except for the two configs, import the old sql db, fix the two configure files to point to the right place (I really screwed that one up.) and you're done.

Good Luck.

[joejoejoe]

That's a lot of work. I hope they're paying you more than a six-pack for it.

There is a fix cache key utility that is supposed to be run when you move servers. It's somewhere on the ZC site. I've read and re-read what it's doing but it's over my head. That might need run too. And you might want to go into the developers tool kit on the admin panel(or just grep it yourself if so inclined) and search for any instances of your old site still showing. I found today that I'd neglected to fix the error logging and phpsitemaps locations, I think there were a total of four references to old locations hidden throughout all the files. I just stumbled on them while searching for the old prefix for my sql db tables, and for the original physical URL.

Have fun.

[schoolboy]

Moving TO GoDaddy is like booking a holiday at a prison.

If anything, they should be moving FROM GoDaddy.

It is arguably the worst possible hosting environment for eCommerce.

MANY posts on this forum give the reasons why GD should be avoided for anything more complex than a one-page HTML site showing pictures of your pets.