Importing Database into new Installation

[DrByte]

Again, all of the data is in the imported database and viewable via phpmyadmin. The store does not display the contents when viewed though.

Right, and that's to be expected, since you've got it pointing to the wrong tables in your database:

The Old Config - Exported:
define('DB_PREFIX', '');

The new Config - Imported:
define('DB_PREFIX', 'zen_');

a) Your old database has no "prefixes" on the table names.
b) Your new database has "zen_" as a prefix before each table name.
c) If you imported the "old" database w/o prefixes into your "new" database, you'll see that you have two sets of tables ... one w/o prefixes, and one with.
Just scroll down the list of tables, and you'll see a complete extra set that start with "zen_".

So, you need to do two things:
1. edit your 2 configure.php files, and set the DB_PREFIX to '' (two single quotes)

2. use phpMyAdmin and manually delete all the tables starting with "zen_".
Be careful you don't delete other tables starting with the letter Z by mistake.

[MagicMan]

Is there a way that I can do the opposite. Transfer the empty table with the data and rename it to Zen, so that I do not have to go through this again in the future and because I also have 2 other sites that are configured properly and I would like to keep everything symetrical and easy to use.

[DrByte]

If you learn how to do installs on your own, you'll be able to set up new sites as you want them to be.

I recommend *not* using "zen_" prefixes. "No prefix" is much less complicated.


I'm not sure what's "complicated" about correcting the DB_PREFIX to match what's needed in your database ... esp since you've got to edit the configure.php files for a move anyway.

[MagicMan]

I got it.

Yes, I do know how to do a manual installation it just seemed so much easier to do it through CPanel.

Can I just FTP a backup copy of the original install to my new server?

If I do this I think I still need to load the Install file and do an installation over before I import the database. Yes?

Bye the way, thank you for taking the time to discuss this with me it is greatly appreciated..

[DrByte]

Can I just FTP a backup copy of the original install to my new server?

If I do this I think I still need to load the Install file and do an installation over before I import the database. Yes?

Much like the FAQ I referenced earlier, yes.
1. FTP the files to the server
2. PROTECT ... make a backup of ... BOTH configure.php files, and mark the uploaded ones as read-write
3. Ensure that the zc_install folder is also uploaded (and matches the version of the Zen Cart files you're using)
4. Run zc_install to set up the database and build configure.php files specific to the new server, being sure to use the same DB_PREFIX.
5. Import the database backup into the new database.
6. Login to the admin and fix the session directory, as per the FAQ.

Basically ... just follow the FAQ :)

[MagicMan]

I resolved the issues. Thank you so much for your assistance. Everything is working fine. Everyone in this forum is top knotch and should be proud of yourselves. Outstanding job.

Thread can be closed