1

Resolved

mysql import error

description

Error during import. Database November 2012. Mysql version 5.5
I am getting following error. please help me. I have already tried redownloading the archive for 3 times and it did not help

Unhandled Exception: MySql.Data.MySqlClient.MySqlException: Incorrect string val
ue: '\xF0\x9D\x94\xA2\xF0\x9D...' for column 'profile' at row 1
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& i
nsertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affected
Rows, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior
)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at DiscogsNet.Database.ArtistInserter.Insert(Artist artist)
at DatabaseManagerCli.Program.ImportArtists()
at DatabaseManagerCli.Program.ExecuteCommand(String command)
at DatabaseManagerCli.Program.Run(String[] args)
at DatabaseManagerCli.Program.Main(String[] args)

comments

karamanolev wrote Mar 18, 2013 at 5:56 PM

I have fixed numerous errors to get the latest dump to import, but that wasn't one of them. I am successfully importing the dump with the latest version. I can't recommend anything else but try another PC with a fresh copy of all archives from the dump.

wrote Mar 18, 2013 at 6:00 PM

wrote Mar 18, 2013 at 6:00 PM

wrote May 16, 2013 at 8:25 AM

wrote May 16, 2013 at 8:25 AM

wrote Jun 14, 2013 at 7:05 AM

HCruz wrote Sep 7, 2014 at 5:10 PM

Hi!
I'm having the same error: using Mysql version 5.6 and database dump of september/2014.
I tried to fix this problem changing data definition for utf8mb4_general_ci, but it didn't work yet.

Any idea how to fix it?

karamanolev wrote Sep 7, 2014 at 6:58 PM

HCruz please verify your archive is not corrupted. Use the checksums provided.

phr35 wrote Nov 30, 2014 at 4:03 PM

Hi,

I'm having exactly the same problem with the last release of DatabaseManagerCli (built on my PC) during import of artists with the discogs file of November 2014. This happens around 65.55 % of the processing:

Incorrect string value: '\xF0\x9D\x94\xA2\xF0\x9D...' for column 'profile' at row 1

My MySQL server version is 5.5.20.

I am sure my discogs file is not corrupted : I can check on my Cygwin environment :
$ sha256sum -c discogs_20141101_CHECKSUM.txt
discogs_20141101_artists.xml.gz: OK
discogs_20141101_labels.xml.gz: OK
discogs_20141101_masters.xml.gz: OK
discogs_20141101_releases.xml.gz: OK

I've had the same idea as HCruz : change utf8 to utf8mb4... but I got the same exception.

Thanks for any idea about this issue.
Regards.