LIMS.eu

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 Now give your database a name.

3 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 SQL Basics).

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