distal-attribute
distal-attribute
distal-attribute
distal-attribute

Error 1064 when loaded sql-dump

giordano2 posted 1 year ago in Import/Export
I wanted to load an sql dump from a MySQL-server into my MariaDB Server and I got the following error message:

SQL Fehler (1064): 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 '?# MySQL-Front 4.2 (Build 2.77) /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */' at line 1.

Since the dump is 1.5 Gb I didn't want to open it. Does anyone knows what this error means and how I can handle this?
Thanks for help.
giordano2
ansgar posted 1 year ago
I guess there is something before that ?# which is not valid SQL. I'm afraid you have to open your dump file into some editor.

How old is that dump? I'm just asking as MySQL Front is no longer maintained for several years now.
giordano2 posted 1 year ago
Thanks for the response. I don't know which version of MySQL was used. I will try to get the info and I will extract the first hundred rows with Perl. I will have access to the dump next week.
giordano2 posted 1 year ago
I extracted the first 100 rows of the dump and it was a dump with only inserts. I needed also the CREATE TABLE since only an empty database was defined.

Please login to leave a reply, or register at first.