close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

restoring backed up database

Thread began 3/13/2013 7:17 am by JamieEff | Last modified 3/14/2013 1:48 pm by JamieEff | 663 views | 8 replies |

JamieEff

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

JamieEff

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?

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

JamieEff

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

JamieEff

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

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

JamieEff

thanks Jason

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...