AnsweredAssumed Answered

Restore from Backup

Question asked by kht on Mar 23, 2017
Latest reply on Mar 23, 2017 by wimdecorte

I have a question on backups. I have a database with around 30 tables and around 5000 records. I am constantly updating the databases. If I was to do something and accidentally delete something critical, how would I go about restoring the database? I backup twice a day, so simply opening a backup is easy. How  could I import the records which have been created in the newer version of the database?


Following on from that, if I am working on an updated version of the database and I wish to make this live, how would I go about importing the data from the older live version? My worry is that if I simply import the tables, modification times, record ids etc may be out of sync. What is a sensible approach? Should I have a restore script?


The problem is that currently all changes have to be done on a live database, which is risky.