Database

On the Database tab, you can change the database connection settings, check the main and log database's status, and perform backup and recovery. You can also see information about the current version of the database, available updates, and also a warning in case there is a need for an upgrade.

Backing up MyQ data

To back up your MyQ data:

1. Open the Database tab.

2. In the Main Database section, click Backup.

3. Provide and confirm a password to protect the backup. If skipped, the backup will be created unprotected.

   

4. A new backup file is created, called backup_*.zip. Depending on the database type, the backup_.*zip either does or does not contain the MyQ database file (MyQ.FDB): the MyQ Embedded database is part of the folder, whereas the SQL database is stored on the SQL server. Besides the MyQ database, the folder contains additional files with data used by the MyQ system, such as reports, certificates, the metadata.backup file or the config.ini file.

Restoring MyQ Data

To restore your MyQ data:

1. Open the Database tab.

2. In the Main Database section, click Full Restore…. Select the backup_*.zip file to restore MyQ Data, and click Open. If the backup is password protected, there is a prompt to provide the password. The database is restored and, if needed, upgraded as well.

Database Connection Settings

In the Connection Settings section, you can view database information, such as the name, server address, server port, username, and password. If you click Edit, you can set up a new MyQ Embedded database or an SQL database. This change is only available if you selected the MyQ Embedded database during the installation.