Table of contents

MIDAS Documentation v4.37

Manage Database Settings

The database settings screen may be accessed via MIDAS Admin Options → Manage MIDAS → Database, and contains a number of settings relating to the actual database(s) in your MIDAS system.

Database Admin

This section contains a number of settings relating to multiple databases:

Show Database Selector on Login page

If this option is selected, and more than one database is defined, users will be prompted to choose which database they wish to log in to and use from the login page.

Create New

Allows you to set up another MIDAS database, running in parallel, on your server - provided your existing MIDAS license allows. You may wish to have multiple databases running in parallel via the same interface if, for example, your business has multiple offices/site locations and you want to have a separate database for each. If your current license doesn't allow you to create any additional databases, please upgrade your license.

However, if your license is valid for creating additional databases, clicking / tapping this button will open a pop-up to allow you to set up your new database. You will need to give your new database a name, as well as set up the initial user(s). Options for the initial user are as follows:

  • Transfer You & Your Permissions - This option will create the new database, and copy your login details from the current database to the new database.
  • Transfer All Users & Permissions - This option will create the new database, and copy all users of the current database to the new database.
  • Create new Admin User - Create a new database with a new administrative user. Selecting this option will prompt you for further details about the new user.

If your database is to be created on a different server to the current database, you will need to untick the "Use Current" Database Host option, and enter details for the new database server.

Use the "Show Advanced" options to control additional database creation options, including enabling table encryption and setting an encryption key ID.

Set as Default

Select a database from the database drop-down, then use this button to make it the "default" database. This database will be selected by default on the login page (Users may still change databases, provided the "Show Database Selector on Login page" is selected, otherwise the default database will be used)

Rename

Rename the selected database.

Delete

Remove the selected database.

For safety, you cannot remove the database you are currently logged into - To remove the current database, you will need to log out, log into another database and delete from there

Database Backups

MIDAS automatically backs-up its database(s) upon the first logon of each day, however MIDAS does not perform automatic backups on days when there are no logins, and therefore no new activity

Current Backups

Lists all backups of your MIDAS database(s) currently stored on your server. The list shows the date & time of the backup, and the amount of disk space being taken up by the backup.

Backup Now

Create an instant backup of the current database.

Delete

Delete the selected database backup.

Restore

Restore your MIDAS data from the selected backup. Selecting this button will open a window allowing you to selectively choose which parts of the database to restore (i.e. bookings between two dates, client, invoices, etc). Alternatively you can select "Everything" to completely roll back MIDAS to the state it was in when the selected backup was taken.

Warning: Restoring a backup will overwrite any data added/modified in MIDAS since the date of the backup

Keep Server Backups

Controls how long MIDAS backups will remain on your server before being automatically deleted to conserve disk space. If the "Forever" option is present and selected, backups will remain on your server indefinitely, however you can still manually remove these backups at any time via the "Delete" button.

For additional piece of mind, if you enter your e-mail address in the "Email Backups To" field, MIDAS will automatically email a copy of the backup to that address every time it makes one.

Then, in the unfortunate event you lose data on your server, you can upload these backups to your /BKUPS directory and restore them from within MIDAS.

Database backups are usually very small in size, as they are compressed. Typically, each backup will usually be less than 500Kbytes in size!

The "Forever" option is not available if you subscribe to a "cloud hosted" MIDAS system
MIDAS » Documentation » Manage Database Settings