To move your site to hosting you do have to move the database by restoring it to the host. If you don't do that then it will be like a new installation on an empty database at the host.
All the pages and content in the site except for user uploaded files is in the database not in the file system, so just copying the files is not sufficient to move a site.
The only exception to this is if using a file based database like SQL CE (which has a file on disk so when you copy the site the database file is also copied), but SQL CE is not as robust a database, a site will run much faster with MS SQL database. It sounds like your current site is using a local MS SQL database. Again, to move it you should clean out all the files you already uploaded since you tried upgrading the files on the host now are not all of the same version as your local copy, so start over. And you will need to get a backup of your local database and restore it on the host and set the connection string at the host to the hosted database after it is restored.
If you already had a database at the host that was working then I would never move again from local to the host, but always if I want an updated copy of the data I would get a backup from the host and restore it local for testing but never try to go back and forth with the database, only go one direction after deploying to production and that direction would be getting a backup from production and restoring it locally for testing.
If you are doing custom development of your own features and need to redeploy custom code to production the right way to do it will depend on if you are working with the mojoPortal source code or developing against release packages.
Hope that helps,