None of your products are showing on the front end, probably because you've got URL rewriting turned on in some mod, but you don't have URL rewriting support active in your hosting account.

So ... backing up a bit. If your localhost version works fine, then you need to sort out what you've got different between the server and your local PC. If it's URL rewriting, then you need to make that work the same in both places. If it's the DB_PREFIX then you need to make that the same in both places. In fact, pretty much everything needs to be the same in both places, with the exception of the specific paths in the configure.php files (those paths are unique to each server).

And this is no longer an upgrade issue specifically, since this is now about moving data between servers.

FYI, this is how I always do my upgrades: http://www.zen-cart.com/entry.php?3-...d-of-upgrading ... which never involves replacing any of my live database contents. It's explained in the article.
Of course, it's too late for you to use that approach now, but it's worth remembering for future, and useful for future readers of this discussion to note.