no database after server move

[skipper_2]

The strange thing is when I installed zencart on the old server I left the prefix blank? so I am not sure why the file is saying the prefix is webstore. Should I run a clean install on the new server and use the DB_PREFIX webstore when I set it up?

[DrByte]

Do you have access to phpMyAdmin?

What are the names of the tables?
How many tables do you have?
Do you have any that start with "webstore"?
Do you perhaps have 2 sets of tables ... one with and one without the prefix?

[skipper_2]

just changed the DB_PREFIX to webstore in the configure file and its all appeared and running great!, thanks for all the help I thought I had really messed it up!

[skipper_2]

I looked in phpmyadmin and you are right DrByte, I seem to have a set that have no prefix and a set that all start with webstore. No clue how I did that. Should I delete all the ones without the webstore prefix?

[DrByte]

Probably best to delete the ones you're not using, or you'll end up with confusion again later.

You "ended up" with them because when you first installed Zen Cart on your server, you didn't specify a table prefix. Thus, it created tables using "nothing" as a prefix.
Then, you imported your real data that has different tablenames ... and they all sit happily side-by-side not even knowing each other exists. That's the whole reason for prefixes ... to allow multiple sets of data for multiple purposes ... often not even related to Zen Cart.

[jpsbears]

Thank you guys soooo much! I know this post is older but it just helped me. The default prefix now is znc when I first installed it was zen. A quick change to my configure.php files and it works.