Moving full installation w/ template+content to new Cpanel account

I need detailed instructions on moving a full zencart installation with template and full store content I've added to a new cpanel account, on a new domain and ip. The old domain it was on has to keep it's ip and 301 redirect to the new domain which must be the same exact store fully functional. I know there is some sql involved.

https://www.zen-cart.com/tutorials/index.php?article=100

Depending on your host they should do it for you for free or at least help you out with any steps you have questions on.

Edit timed out by 1 minute :cry:

Basically what I do is:

Install a fresh zen cart of the same version, this way the configure.php files are correct.

Download all files from your old site, delete includes/configure.php and admin/includes/configure.php

Go into phpMyAdmin (on old server), click on the zen cart table you're using. Select all of the tables and export them.

Upload files to your new server over-riding all zen cart files installed.

Go into phpMyAdmin on the new server, select the zen cart table. Select all tables and Drop them. Go to Import, and import the old sql file you previously downloaded.

Your good to go!

(Don't delete ANYTHING on the old server until you verify that your new site works 100%)

As far as the redirect goes use cPanel to add a 301 Wildcard redirect from old domain to new

what does leaving out the two includes/configure.php files do? And most of all, thank you :)

The two includes/configure.php files are specific to the installation. Leaving them out preserves the information created for the new domain.

what to do if the new install has folder admin and the old website has it renamed to admin1, does it mess this copy over method up ?

You'll need to upgrade the files in your renamed admin folder just as if it were still named "admin"

I cant get the tables to import. Can someone please explain the process in more detail ?
Also how do I do it as though it were still named admin ?

Its giving me, when I go to import the tables:

SQL query:

-- -- Database: autotech_new -- -- -------------------------------------------------------- -- -- Table structure for table address_book -- CREATE TABLE IF NOT EXISTS address_book ( address_book_id int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', entry_gender char(1) collate latin1_general_ci NOT NULL default '', entry_company varchar(64) collate latin1_general_ci default NULL, entry_firstname varchar(32) collate latin1_general_ci NOT NULL default '', entry_lastname varchar(32) collate latin1_general_ci NOT NULL default '', entry_street_address varchar(64) collate latin1_general_ci NOT NULL default '', entry_suburb varchar(32) collate latin1_general_ci default NULL, entry_postcode varchar(10) collate latin1_general_ci NOT NULL default '', entry_city varchar(32) collate latin1_general_ci NOT NULL default '', entry_state varchar(32) collate latin1_general_ci default NULL, entry_country_id int(11) NOT NU[...]

MySQL said:
#1046 - No database selected

And another error. I have everything done but I cant get the tables over

MySQL said:
#1046 - No database selected'
If using phpmyadmin you must select a DB first

If you still have access to your old cpanel account see if they provide you the ability to create a "FullSite Backup"

See if your new host will restore from the backup file generated from that

It will contain ALL details from your old account, mail, users, DB's, files etc

Ok I dropped the tables so I dont get that error anymore. But fix_cache_key doesnt appear to be working and newdomain/index.php still takes me back to setup even though I already did that setup

what code does fix_cache_key run ? I have to do it manually, that script isnt displaying anything when I run it and my index.php still takes me to setup even though I alreaedy did setup

Sounds like you have problems beyond the scope of Zen Cart if both the index.php and the fix_cache_key.php files don't work.

Note the tutorial link given in post#2 earlier. Did you follow that? Did you keep the correct DB_PREFIX when setting up the new site? Most people just ignore that step and then come here and post symptoms like you're mentioning.

DrByte:

Sounds like you have problems beyond the scope of Zen Cart if both the index.php and the fix_cache_key.php files don't work.

Note the tutorial link given in post#2 earlier. Did you follow that? Did you keep the correct DB_PREFIX when setting up the new site? Most people just ignore that step and then come here and post symptoms like you're mentioning.

You got it exactly right in my case, that was something I had skipped, I didnt ignore that step on purpose. I checked the original one and it was ' ' or something. I didnt know how to set that parameter on the new server.

I didnt ignore that step on purpose. I checked the original one and it was ' ' or something.** I didnt know how to set that parameter on the new server.**
That is a setting in the DB info in both of your configure.php files

they were both the same, appeared to be blank, it was like ''

Old Server

includes/configure.php :
define('DB_PREFIX', '');

admin1/includes/configure.php :
define('DB_PREFIX', '');

New server

includes/configure.php :
define('DB_PREFIX', '');

admin/includes/configure.php:
define('DB_PREFIX', '');

admin1/includes/_configure.php is in there but there is no
admin1/includes/configure.php

I hope this is enough for one of you kind more experienced ones to tell me why things aren't working.

do I need to change anything there ?

No that seems right