drizzledump of text columns returning errors during import process
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
High
|
Andrew Hutchings | ||
7.0 |
Fix Released
|
High
|
Andrew Hutchings |
Bug Description
The drizzledump-
We see this error during the dump/import process:
Error executing query: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near ''ÿØÿà\' at line 1
The dump output is the same whether using drizzledump or mysqldump. The offending INSERT statement begins:
INSERT INTO `dump_table1` VALUES ('ÿØÿà\^@^PJFIF\
My initial thought is this is due to a charset / collation issue as MySQL is using the default charset / collation while Drizzle isn't using the same sets.
I'll provide the MySQL dumpfile for the table so that you can recreate it / try to import it yourself.
My drizzledump command line:
MySQL running on port 19300, Drizzle on port 9306, db used = drizzledump_db
drizzle/
Related branches
- Brian Aker: Approve
-
Diff: 39 lines (+17/-2)1 file modifiedclient/drizzledump_data.cc (+17/-2)
Changed in drizzle: | |
importance: | Undecided → High |
milestone: | none → 2010-10-25 |
status: | Confirmed → Triaged |
Changed in drizzle: | |
status: | Fix Committed → Fix Released |
Hi Patrick,
I can't import your dump file into MySQL either (5.1.51), it has the same error. I suspect this is an escaping issue with both libmysqlclient and libdrizzle (or it is not valid UTF8 data). But I will need a way to reproduce it (the original insert statement I guess)