Moving to a different domain

I am moving a closed zen-cart to a different domain simply so I can easily retrieve financial information. The closed domain will be redirected to another domain, but I still need access to the closed admin.

I have moved all files and the db to the new location and I am stepping through the zc_install. I have encountered an issue:

Installation In Progress...

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1
in:
[CREATE TABLE zen_upgrade_exceptions ( upgrade_exception_id smallint(5) NOT NULL auto_increment, sql_file varchar(50) default NULL, reason varchar(200) default NULL, errordate datetime default '0001-01-01 00:00:00', sqlstatement text, PRIMARY KEY (upgrade_exception_id) ) TYPE=MyISAM;]

:no: Can anyone tell me what I have done wrong or better yet, what I need to do to fix this?

Thank you,
Christy

Ok, I had the username and password wrong in the configure.php file. Oops :blush: But maybe that wasn't even the problem.

Now, back to the Database Information page. If I already uploaded the database, how do I do this? I have entered the Host, Username, Password, and DB Name correctly and it is still giving the error message posted above.

Thanks,
Christy

Replace. TYPE=MyISAM. with. ENGINE=MyISAM

EDIT: Since you're installing the old v1.3.8a from 2006 which was designed for an older version of MySQL, you'll need to do that replace in the core Zen Cart zc_install files in the /zc_install/includes/classes/*.php files and the /zc_install/sql/mysql_zencart.sql file.

First you install Zen Cart with the demo data. Be sure to use the same Table Prefix during zc_install as you've got in the DB_PREFIX of your OLD configure.php files.

Then you import the old database to replace the demo data with your own data.

The whole process is outlined here: http://www.zen-cart.com/content.php?142-i-want-to-move-my-zen-cart-installation-to-another-host-or-a-different-server