On the Database tab, you can change the database connection settings, check the main and log database's status and perform backup and recovery, and encryption. 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.

MyQ Central Easy Config - Database tab

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.

    Backup password prompt
  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 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.

MyQ Central Easy Config - Restoring data

Restore Data process window

Encrypting the main database

For better security, you can encrypt the main database using a certificate. MyQ does not provide these certificates. You should install and use your own. Once installed, they will be visible in the Certificate drop-down. This functionality is only available for MyQ Embedded Databases. If you have an SQL Server, this section for encryption/decryption is not displayed.

Database tab, Encrypt button

During the encryption, other services will not be available. A busy indicator will let you follow the encryption/decryption process:

Encryption process window

After the encryption, the Encrypt button will change to Decrypt so you can reverse the action.

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 Change, 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.