Question about moving a Zen Cart...

[RiverRat]

I've got a Zen Cart hosted with Sashbox. 

Currently, the site is not open for business so that part is not a problem.


I'm wanting to move it and I don't care if I lose the customer database. 
The only thing I want to make sure I preserve is the site with it's installed mods. 
Is this possible and if so, how do I do this? 

Thanks!!

[bargainbloodhound]

[quote author=RiverRat link=topic=11615.msg55190#msg55190 date=1180538876]
I've got a Zen Cart hosted with Sashbox. 

Currently, the site is not open for business so that part is not a problem.


I'm wanting to move it and I don't care if I lose the customer database. 
The only thing I want to make sure I preserve is the site with it's installed mods. 
Is this possible and if so, how do I do this? 

Thanks!!
[/quote]

Very possible--you could even install it on multiple domains (just change the database name for each site).

To move the cart:  Backup the database: either with phpmyadmin or the backup mysql mod from the Zen site. 

Move the files to the new server and change the paths in the Zen config files if necessary and set permissions, etc. Create a database (if the name is different than your old database just change the two Zen config files) and use phpmyadmin to import the database backup from the old site.

[RiverRat]

Thanks so much BBH!

That doesn't sound quite as bad as I anticipated. 
You mean I've been reinstalling the basic mods I always use on each of my sites for no reason?  :blinkie:   


Off to see how bad I can screw this up. 

[RiverRat]

  This is not going so well. 

I followed the directions above and I'm pretty sure I did everything I was supposed to do.
I changed everything in the configure.php files

After importing the database I'm getting this error:

1146 Table 'oldescom_candletzencart.TABLE_SEO_CACHE' doesn't exist
in:
[DELETE FROM TABLE_SEO_CACHE WHERE cache_expires <= '2007-06-05 13:18:10']

What have I done wrong or missed?
I know nothing about this database stuff!  :blinkie:
I probably need to buy "Databases for Dummies". 

[regic]

What versions of MySQL are your old site and new site using?

[RiverRat]

The old host says:

Server version: 4.1.21-standard-log
Protocol version: 10
Server: Localhost via UNIX socket

MySQL client version: 4.1.10


The new host says:

Server version: 4.1.21-standard-log
Protocol version: 10
Server: Localhost via UNIX socket

MySQL client version: 4.1.21

[regic]

Try this:

For anyone else who got this problem please be advised that you must rename the TABLE_SEO_CACHE in your mysql database to seo_cache

http://72.14.209.104/search?q=cache:gnF7...%27t+exist&hl=en&ct=clnk&cd=2&gl=us

To rename a table, in PHPAdmin go to the SQL tab and use this command:

Code:

RENAME TABLE old_table TO new_table;

[RiverRat]

Thanks for help Regic!

I did that and it said:

#1050 - Table 'seo_cache' already exists


And I'm still getting the same error as before.  Grrrrrr! 

I take it this has something to do with the Ultimate URLs which I never could get to work exactly right and had turned off on this cart. 

[regic]

Ultimate Seo URLs v 2.1.0.3 is the mod version that works on mySQL 4.1.2x

[RiverRat]

Is there a way to remove the Ultimate Seo Urls mod from the database?