I am trying to move an existing store but there is a mismatch with the tables in the database.
This is not an update question ... I think
The Current site has a working v1.3.8 Zen-Cart
I have exported the DB using phpmyadmin, basically accepting the defaults.
The I attempted to 'restore' the backup into a fresh install at new hosting service.
The Zen-Cart version for the new install is v1.3.8 as well.
The restore process is failing.
It appears that the NEW db has "zen_paypal_testing" table, whereas the current site does not.
All other tables have identical naming syntax.
The table prefix is same for both mysql db's.
To verify, I cut-n-paste the table names into temporary files, then used WinMerge to compare nameing syntax..etc.
Please help me work trough this.
Original site was updated about a year ago from v1.2.7 - v1.3.8
I have not updated either site to 1.3.8a yet.
Current Site
(94) tables in db
Zen Cart 1.3.8
Database Patch Level: 1.3.8
v1.3.8 [2007-12-19 22:29:23] (Version Update 1.3.7->1.3.8)
v1.3.7 [2007-12-19 22:28:57] (Version Update 1.3.6->1.3.7)
v1.3.6 [2007-12-19 22:28:41] (Version Update 1.3.5->1.3.6)
v1.3.5 [2007-12-19 22:28:21] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2007-12-19 22:27:41] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2007-12-19 22:26:47] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2007-12-19 22:25:53] (Version Update 1.2.7->1.3.0)
v1.2.7 [2006-03-02 13:56:59] (Fresh Installation)
----------------------
NEW site
(95) tables in db
Clean Install setup on another hosting service
uploaded from "zen-cart-v1.3.8-full-fileset-11302007.zip"
Zen Cart 1.3.8
Database Patch Level: 1.3.8
v1.3.8 [2009-01-02 23:12:32] (Fresh Installation)
v1.3.8 [2009-01-02 23:12:32] (Fresh Installation)
----------------------
?? Can I simplly copy the section of the sql file for "zen_paypal_testing" from NEW database backup and paste into the sql file I am trying to restore.
One other question concerning charset..
Current table... ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=359 ;
New Table....... ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
?? Can I do I find/replace in Current file and replace latin1 with utf8
Thanks
Bookmarks