How To Manage Database Settings

Topics covered in this tutorial:

• Rename your MIDAS database.
• Adding additional databases.
• Setting a default database.
• Allowing users to select which database to login to.
• Removing a database.
• Database backups.
• Perform an instant backup.
• Control how long server backups persist.
• Email daily backups to a pre-defined address.
• Deleting a backup.
• Fully restoring a database backup.
• Partially restoring a database backup.
• Additional database tools.

Tutorial Video Transcript

In this tutorial I'm going to show you how you can manage database settings.

You'll find these settings by going to MIDAS Admin Options and selecting "Manage MIDAS" from the drop-down, and then on the Manage MIDAS screen select the "Database" tab.

Here we can rename our database - so we can call it "Tutorial 2" for example.

And if your MIDAS is licensed for multiple databases, then you'll be able to click "Create New" and add a new database to your system.

All the databases you add will share the same common login screen, but you'll see there's an option here is show database selector on login page and if that's selected then when your users come to login on the login screen they simply select which database they wish to login to.

Below the database admin section is a "Database Backup" section.

Now MIDAS automatically takes a backup of its database and settings upon the first successful login each day, and you'll see these backups are listed here.

If we wish to revert our database back to an earlier point in time, we can simply select the database and click "Restore".

MIDAS will then ask us which elements of the database we wish to restore, or we can select "Everything" to restore the entire database, and we can then click "Restore".

MIDAS will revert the database back to this specific point in time.

In addition to the automated backups that are taken daily upon the first successful login, we can also click "Backup Now" and MIDAS will generate a backup instantly.

These backups are stored on the server where your MIDAS system resides, and you can choose for how long they'll stored from this drop-down.

Please note, the "Forever" option is not available in the cloud hosted edition.

Additionally, you can enter an email address here, and each time an automated backup is made not only will it be stored on the server but you can also have it emailed as an attachment to the address you specify here.

So this is a great way of keeping off-site backups in addition to your server backups.

The final two parts of this screen relate to exporting data and this is covered in a separate video tutorial, and there's also a "Database Tools" drop-down here with tools allowing you to import data, merge data, and clean up your database.

Again these are covered in separate video tutorials.

Thanks for watching and be sure to check out some of our other tutorials online.