no database after server move

[skipper_2]

Hi,
Hope someone can help me with this. I moved my zencart store from one server to another following the instructions in the tutorials.

I backed up the old database tables with phpmyadmin and repopulated the new database with the sql file. All seems ok with the database as it has the same amount of tables as the old one.

I have checked both the configure files and they have the correct paths. I have also run the fix cache key and that is reporting the correct path. Thing is when I open the site there are no products although the database is fully populated with over 100 products. Also when I log into admin, it says 0 products but the sessions path is correct

site address is http://www.directtropicals.co.uk.

I would be most grateful if someone can help as it is beyond my knowledge on what it could be.

Thanks
Skip

[Chuckl]

You should have a look at the products and categories tables with phpMyAdmin or similar, and see if the tables have anything in them.

[skipper_2]

Thanks for the advice, I had a look and there is no products in there. Am I doing something wrong when I import the database?

[Chuckl]

Check the SQL backup/export file from your original database. There is sometimes a 'USE database_name' included, which would obviously be the original database, not the new one. If so, change it to the new one, comment it out or delete it.

[skipper_2]

Have done that and reimported and still says products 0.

If I look at my original database it says products 0 but it is fully operational on my test site with about 200 products? Im not very good at this stuff but is that odd?

[skipper_2]

Just to add to my confusion, when I log into admin now after redoing import, all my products are in there but still no sign on the site?