search

snarfblam / Prop-manager

Property management and tenant service web application
7 stars 7 forks source link

Database Backup #67

Open snarfblam opened 6 years ago

snarfblam commented 6 years ago

This is an important feature. At the very least, an administrator should be able to download the database as a json file. Even if we don't initially provide a method of restoring the database from a backup, it gives the admin a way to avoid total data loss in the event of a hardware failure or catastrophic bug.

Down the road, we would want to have some kind of automated backup and a means to restore from backups.

aknight023 commented 6 years ago

I believe JAWs db has automated backups. i remember seeing that somewhere.

snarfblam commented 6 years ago

You're right. JawsDB plans and pricing

It may still be nice to be able to dump/insert the database to switch between services or if you want to use a service that doesn't offer automatic backups (though I'm guessing anything but self-hosting comes with backups). Even then, it's possible to do these things via command line or MySQL Workbench.