I just followed each step of these instructions: http://doc.silverstripe.org/doku.php?id=publishing-to-web-server
Now when i visit my live site only the default Silverstripe pages (home, contact, about us) with default content are there. The theme is displaying correctly, and I did the export/import in phpmyadmin. No errors were mentioned in the process, just "110 queries were complete successfully". I did remember to click the "Add DROP TABLE / DROP VIEW" checkbox when exporting from phpmyadmin.
My pages still do not show up. They are still working on my localcopy, so I'm sure that they are not missing from the DB. What table(s) are pages stored in. Perhaps they were not listed in the left hand column in phpmyadmin where you choose which tables you'd like to export for some reason? (I did select all of course when exporting).
Another thing I found odd is the number in parenthesis next to the database in my local version (i think this is # of tables?) is lower than on the live version. I expected them to match.
Thanks in advance!