Procedure for using 'Database Restore'

5 posts by 2 authors in: Forums > CMS Builder
Last Post: December 26, 2012   (RSS)

By Deborah - December 21, 2012

I am looking for instructions for use of the database restore feature located in the admin general settings (CMSB version 2.50). I thought it would be as easy as selecting the database version to restore and clicking the 'restore' button. What resulted is a new set of errors in CMSB admin relating to a field name that did not exist at the time of the backup.

I only chose to restore the backup database, because I renamed a field which caused a glitch within CMSB that would not allow me to update the associated editors relating to that field. I simiply could not get there. I've renamed fields in other versions of CMSB, then can update any records relating to that field, but not in this case.

Should I have done something other than select the backup database to roll back? It appears I'll have to start over again with this build and data entry, but I would like to know for future reference.

Thanks for any help.
~ Deborah




By Dave - December 21, 2012

Hi Deborah, 

Are you trying to merge some new data and fields you've created since the backup or just restore the backup?  

Generally you need everything to match up, so the /data/schema/ folder (or the fields under the field editor) should be the same as when the backup was made).

If you are getting errors because there is a field in the schema (created in the field editor) that doesn't exist in the MySQL Database you can just click on "Section Editors" and it will automatically check and re-create any fields that are missing from the MySQL.

What are the specific errors and where are they appearing?  

Let me know and I'll try help.  Thanks!

Dave Edis - Senior Developer

By Dave - December 24, 2012

Hi Deborah,

Ok, do you still need a hand with it?  If so, feel free to email the details to and I can take a look for you.

Note: Email, don't post login details to the forum.


Dave Edis - Senior Developer

By Deborah - December 26, 2012

Dave, I appreciate you checking in, but I'm all set on this. Your initial reply helped me out.

Thanks again, Deborah