Error 1064 when loaded sql-dump

giordano2's profile image giordano2 posted 11 years ago in Import/Export Permalink
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's profile image ansgar posted 11 years ago Permalink
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's profile image giordano2 posted 11 years ago Permalink
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's profile image giordano2 posted 11 years ago Permalink
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.