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.