• Registered: 2007-05-21
  • Posts: 6

Topic: Weird problem exporting/importing database

Hiya,

I have exported my DB from where it is hosted online in an attempt to backup my data and get a local copy working to run tests on etc.

I managed to export everything and then import into a fresh database VIA php myadmin.

All the logins work, the topic names and forums work but I cannot view posts nor does it display how many posts there are.

I have included some pictures.

**NOTE** I also realised that the active forum link I have on the index page, (which links to an external place) now seems to display a date and time relating to the 1970 neutral


http://img109.imagevenue.com/loc1058/th_41053_index_122_1058lo.JPGhttp://img179.imagevenue.com/loc444/th_41058_viewpost_122_444lo.JPGhttp://img165.imagevenue.com/loc448/th_41059_viewtopic_122_448lo.JPG

Any Ideas?

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Weird problem exporting/importing database

It sounds like your export didn't work properly
In particular, the issue with topics is (I believe) caused by moved_to in the topics table being set to 0 instead of null. Other issues may have come from similar mistakes in the export