Error importing SQL dump into a recent mariadb database
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)