no database after server move

[DrByte]

What was the DB_PREFIX setting on your old server? (in the configure.php files)
What is it on your new server?
If they're not the same, then you won't be seeing the right set of tables in the database.

[skipper_2]

Thanks for the responses, I checked both the includes/configure.php and the admin/includes/configure.php files and they both have the same database settings. However, the old servers DB_PREFIX says webstore in admin configure.php which was the folder i used for zencart and the new one says nothing, should i change the new one to webstore?

[DrByte]

The database tables are named like this:

categories
customers
orders

If you have DB_PREFIX set to something other than blank, those tables will be named differently. ie: if DB_PREFIX is set to 'something_', then the tables will have been built using these names instead:

something_categories
something_customers
something_orders

So ... since your "old" server had a certain DB_PREFIX setting, and that's the data you're carrying forward to your "new" server, you'll need to make sure the DB_PREFIX on your "new" server settings is the same as the "old" server's DB_PREFIX.

[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.