back to manual overview

Save and Display MySQL Laboratory Database Backup Locally

If necessary, you can download the MySQL database that powers the laboratory database as a backup and, if needed, import it locally into a MySQL program such as Workbench.

Preparations

Before creating the backup, you need to download the MySQL Installer:
For Windows users, we recommend the following page: MySQL Workbench including MySQL Server

For Macintosh users, we recommend the following page: https://dev.mysql.com/downloads/mysql/

Important: Besides Workbench, you must also download the MySQL Server

Backup Process

First, download a current backup of your data. To do this, go to: Navigation bar Settings Backup.

There you can create a current backup or download an existing backup. The downloaded file is compressed and must be extracted according to the SQL editor used (e.g.: MySQL Workbench including MySQL Server ). To extract, we recommend using the software 7-zip. Now you need to connect to the local instance. After that, the extracted file can be imported into the SQL editor. You can start the import via the navigation on the left side (see image) or click on Server and Data Import in the menu.



1 Select the extracted backup file by clicking the button with the three dots. 2, 3 Now give your database a name.

4 Click Start and the file will be imported. Depending on the size of the file, this may take 5 to 40 minutes.

Once the file is imported, you now have access to the entire database with the SQL programming language and can, for example, test data access even if the server fails.
In the navigator (far left) are the uploaded files (with the audit trails).

Important: However, the stored files you uploaded yourself are not included. These must be downloaded separately.


To execute SQL commands, you need to click the +SQL icon in the menu. A new window will open where you can insert the SQL commands. To execute the commands, just click the ↯ lightning icon (more on _LINK_TO_PAGE=231_).

Example Code for an SQL Query


SELECT s.name, pt.name, p.* FROM samples s
JOIN parameters p ON p.sample_id = s.id
JOIN parametertypes pt ON p.parametertype_id = pt.id
WHERE s.id = 1

Last change: 10.01.2025

Allgemeines

Einführungsphase

Mitarbeiter

Aufträge

Proben

Probenvorlage

Berichte

Berichtstabellen Editor

Kunden

Kundenzone (optional)

Anlagen

Angebote

Rechnungen

Parameter

Rechnen mit Parametern

Schnittstellen

Webservice

Transformationscode

Prüfpläne / Grenzwerte / Spezifikationen

Dokumentenlenkung

Prüfmittel

Material

Mitarbeiterschulungen

8D-Report

Sonstiges

PDF-Vorlagen

Fragen und Antworten

Lieferantenbewertung

Dateiverwaltung

Auswertungen

Prozesse