OK, I fixed it!!!!
I'm really hoping this helps someone else at some point.
I was migrating a drupal site from a private host to GoDaddy subdomain host to test the files and sql db before going to live environment.
Drupal site migrated and everything looks right but no content is listed. No pages, no media, nothing. The proper theme was available as an option, but not selected.
in the settings.php file, the prefix that godaddy installed for me was "drup_", but my imported database tables didn't have "drup_" as a prefix.
nizz0k was very helpful in pointing out that I need to run update.php. I had already tried that, but his comment about godaddy not allowing enough ram gave me the idea to increase the ammount of ram from godaddy. The error I was getting before increasing the ram, had to do with "not enough ram or exceeding available ram" something like that. As soon as i increased the resource level with godaddy, the update script worked.
So, to wrap it up, if you are hosting with godaddy, beware of the prefix.
- I had godaddy install the drupal app for me in the subdomain
- imported the sql db from my old host
- imported the files using ftp
- edited the settings.php file to get rid of the "drup_" prefix that godaddy had
- go to site.com/q=user to log into the site and have permissions
- go to site.com/update.php to update things
That's what worked for me. I'm really hoping this helps someone out. I was looking for something about this for more than 5 days before I posted the question.
Again, thank you so much for this website for hosting the forum, and most certainly thanks to nizz0k for the prompt response and excellent idea's!!