caosdb-mysqlbackend issueshttps://gitlab.indiscale.com/caosdb/src/caosdb-mysqlbackend/-/issues2022-07-22T09:24:35Zhttps://gitlab.indiscale.com/caosdb/src/caosdb-mysqlbackend/-/issues/38Error importing SQL dump into a recent mariadb database2022-07-22T09:24:35ZAlexander SchlemmerError importing SQL dump into a recent mariadb databaseIs it possible to just import an SQL dump (created by linkahead backup) into a normal maria db database (without further preparations)? I want to inspect the contents of some tables.
I tried (after having created database `caosdb_bmpg`)...Is it possible to just import an SQL dump (created by linkahead backup) into a normal maria db database (without further preparations)? I want to inspect the contents of some tables.
I tried (after having created database `caosdb_bmpg`):
`mysql -u root caosdb_bmpg < dump-filename.sql`
The import (of the tables I needed) seems to be there, but there was an error leading to an interruption of the sql script just before the end:
```
ERROR 1064 (42000) at line 1954: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Offset INT UNSIGNED) RETURNS varbinary(255)
READS SQL DATA
BEGIN
...' at line 2
```
Maria DB version: 10.6.5-2 (on archlinux)Timm Fitschent.fitschen@indiscale.comTimm Fitschent.fitschen@indiscale.com