restoring backed up database

Hey Jason

I use xcloner and a cron job to back up sites automatically and uplaod to an amazon s3 account daily.

I had cause to restore a database (not the files) on a site the other day but the structure of the templates seems to be lost.

As you can see in the attached screenshot of the PCMS2 navigation, the pages in 2 templates (circled in red and green) have become disaccociated as you can see from the relevant coloured 'asterisks'

any idea why this might be and how to stop it from happening as it takes a lot of time to get it back to how it should be.. almost like starting from scratch

cheers

Jamie

those relations are defined by the ContentID, ContentPageSetParentID, ContentPageSetOrder, and ParentID columns

The Export or import must not be backing up / importing the information in those columns properly.

The export should include the ContentID column.

when you import the backup you should drop the table first and reset the cardinality of the ContentID column.

its happened a couple of times (well every time I have tried to restore a backup) and exactly the same thing happens.

its clearly exporting the data as the content is all there it just messes with it.

  when you import the backup you should drop the table first and reset the cardinality of the ContentID column.  

when you say drop the table, do you mean empty pcms2_contents completely?

and re the 'cardinality' is that about setting ContentID to be the primary index?

yes, empty pcms2_contents completely and rest the ContentID cardinality to 0

sorry, what is the cardinality and where would I find it in heidi?

cardinality is the Index number for the last record inserted.

it is how the database tracks what to use for the next Records Primary Key value.

gotcha... so in heidi, that would be under the 'options' tab and putting 0 in the auto increment field right?

I'm not familiar with heidi, but that sounds right.

thanks Jason