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

Error 1064 when loaded sql-dump

User, date Message
Written by giordano2Money, Euro
1 year ago
Category: Import/Export
12 posts since Sun, 03 Mar 13
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
Written by ansgar
1 year ago
4967 posts since Fri, 07 Apr 06
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.
Written by giordano2Money, Euro
1 year ago
12 posts since Sun, 03 Mar 13
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.
Written by giordano2Money, Euro
12 months ago
12 posts since Sun, 03 Mar 13
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.