Error message

sigmasix's profile image sigmasix posted 4 years ago in Import/Export Permalink

Hello,

getting error message when trying to load data from local infile.

BUT ONLY when comment stands in front of query. If there is no comment, loadig data is working.

With comment before query, loading data doesn't work. Strange.

Description

Example:

NOT WORKING: Description

WORKING: Description

Updated today to version 10.3.0.5771 (64Bit)

Description

Cheers

ansgar's profile image ansgar posted 4 years ago Permalink

Very odd. The server rejects it when there's a comment right before it?

Are you sure the second one imported the data from your csv file?

However, it could be I have to activate the MYSQL_OPT_LOCAL_INFILE option in HeidiSQL's connection handler for getting that running.

Could you please report the server version you are running there?

sigmasix's profile image sigmasix posted 4 years ago Permalink

Yes, I am sure.

Query with comment in front is working fine on other machine with older version of HeidiSQL (Version 10.1.0.5464). On my lokal machine (with "Bug") I am running HeidiSQL with Version 10.3.0.5771. Yesterday I updated my lokal client to this version. Before this update Query with comment in front was working fine.

Both clients connecting to same SQL-Server (Version 5.6.20).

ansgar's profile image ansgar posted 4 years ago Permalink

Ok, you did not mention before you were using different HeidiSQL versions. In that case it's likely the updated library which causes the error.

In the v10.3, you have a "Library" dropdown on the session manager. Please post what you have selected there. And try the alternatives there.

sigmasix's profile image sigmasix posted 4 years ago Permalink

OK. I've got results:

Per default (I guess so) library libmariadb.dll was selected.

Tested with libmysql.dll -> no error message

Tested with libmysql-6.1.dll -> no error message

Tested with libmariadb.dll -> error message occurs

You are right: Changing the library solves this issue. So for me it's OK now.

Thank you very much for your help. Great!!!

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