Documentation

MIDAS Documentation v4.20

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 login to and use from the login page.

Create New
Allows you to setup 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 setup your new database. You will need to give your new database a name, as well as setup 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 MySQL server to the current database, you will need to untick the "Use Current" MySQL option, and enter details for the new MySQL server.

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 logout, 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 where 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 your MIDAS is "cloud hosted" by us

Export

This section allows you to export your MIDAS Bookings, Clients, Resources, or Invoice Summaries in a range of different formats for use elsewhere in 3rd party applications, for example spreadsheets, calendar programs, finance packages, etc. Simply select the parts of the database you wish to export. If exporting bookings, you can additionally select the date range of bookings to export. Finally, choose the format for the exported data from the drop-down list and use the "Export" button to begin your export. You will then be prompted to open/save the exported data file.