Trying to upload database to webhost from localhost

Well I am trying to upload my database to the web and I am having issues. I changed my config.php file with the new database. The I exported the database through wordpress export file from the localhost site. Then on the new site I tried to import and I got this error.

The uploaded file could not be moved to /usr/local/pem/vhosts/108867/webspace/httpdocs/blog/wp-content/uploads/2011/04.

So then I tried using the MyPHPadmin. I exported into a .sql file then I uploaded it. I see the files there but when I am in the dashboard wordpress doesn’t have any of the pages or posts.

I tried reading some of the other threads here from past years and just got more confused. Help:confused:

When you export the .sql file what are you exporting? On the new database that you imported to, did you look at the tables in the database after the import to see if the posts table has data, as well as categories? You will need all the data, not just the post table for it to work.

I gave up a long time ago and just redid the pages