Zen Cart Logo
Forums / Installing on a Linux/Unix Server / database shows different versions when exported then imported

database shows different versions when exported then imported

Views: 1,126

Results 1 to 2 of 2
19 Aug 2011, 7:38 AM
#1
kneel999 avatar

kneel999

New Zenner

Join Date:
Aug 2011
Posts:
2
Plugin Contributions:
0

database shows different versions when exported then imported

I am in the process of moving my store to a new host. I read the article here: https://www.zen-cart.com/tutorials/index.php?article=100 about moving zen cart to a new server and followed it to the letter. Although it partially worked (my website has most of the colors/layout correct but with a couple of errors but all products are gone and all the customer/sales information in admin panel is missing also) the admin page said that I needed to upgrade my database file. My current website is version 1.3.9h installed only about 5 months ago. Looking at the sever info from admin panel it says:

(Current working website)
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
v1.3.9h [2011-01-07 02:15:23] (Fresh Installation)
v1.3.9h [2011-01-07 02:15:23] (Fresh Installation)

But after I import the database to the new server it says that it needs upgrading so I upgrade and it shows:

(New server)
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
v1.3.9h [2011-08-19 00:19:12] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2011-08-19 00:19:12] (Version Update 1.3.7->1.3.8)
v1.3.7 [2011-08-19 00:19:09] (Version Update 1.3.6->1.3.7)
v1.3.6 [2011-08-19 00:19:08] (Version Update 1.3.5->1.3.6)
v1.3.5 [2011-08-19 00:19:08] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2011-08-19 00:19:05] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2011-08-19 00:19:05] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2011-08-19 00:19:05] (Version Update 1.2.7->1.3.0)
v1.2.7 [2006-03-12 02:05:22] (Fresh Installation)

I don't understand why the 1.3.9h version database doesn't show up that way when I import it to the new server. It seems to think it is the version 1.2.7
Am I exporting or importing it incorrectly?
I also tried to run fix_cache_key.php but nothing happens.

Here is the SQL and PHP versions of my working site and the new site:
WORKING WEBSITE----

Name: MySQL
Version: 5.1.41
Advanced: InnoDB Enabled

PHP
Version: 4.4.9 and 5.2.11 (as CGI binary using FastCGI)
Supported Database: MySQL
Executable: From "httpdocs" folder
Permissions: Not Applicable

NEW SITE----

MySQL version 5.0.92-community-log
PHP version 5.2.17

19 Aug 2011, 5:56 PM
#2
kneel999 avatar

kneel999

New Zenner

Join Date:
Aug 2011
Posts:
2
Plugin Contributions:
0

Re: database shows different versions when exported then imported

I used the "download my zen cart" add-on and downloaded the database from my existing website and uploaded it to my new one and it worked perfectly!
Great add-on