Content missing from a moved site

Permalink
Hi all,
I created a site on a test domain and now wanted to move it live (where a a recent installation of C5 already existed). So I followed the information in this guide.http://www.concrete5.org/documentation/installation/moving_a_site...

I backed up the database and imported it using phpMyAdmin into the new host. Copied the relevant directories as suggested.

Once it was complete I had to manually change the theme to the custom theme and activate it. However, I'm missing all the content and pages I had created earlier in the old host.

I had a quick look at few data tables. In table btcontentlocal for example I could recognise some of the custom text I have added, but they are not showing up when you browse the site as user or admin.

Any ideas what might be going on?
Thanks