Procedure for using 'Database Restore'
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.
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!