Syntax error on inport of a SQL file produced by drizzledump
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
High
|
Andrew Hutchings | ||
7.0 |
Fix Released
|
High
|
Andrew Hutchings |
Bug Description
After removing my VIEWs from my MySQL schema, I am able to produce a SQL file using drizzledump. However, trying to import this file produces:
root@mcp:~# drizzledump -c -p3306 -uroot -pxyz mcptest > mcp.sql
-- %10000 rows dumped for table Logger
-- %20000 rows dumped for table Logger
-- %30000 rows dumped for table Logger
-- %40000 rows dumped for table Logger
-- %50000 rows dumped for table Logger
-- %60000 rows dumped for table Logger
-- %70000 rows dumped for table Logger
-- %80000 rows dumped for table Logger
-- %90000 rows dumped for table Logger
-- %100000 rows dumped for table Logger
-- %110000 rows dumped for table Logger
-- %120000 rows dumped for table Logger
-- %130000 rows dumped for table Logger
-- %140000 rows dumped for table Logger
-- %150000 rows dumped for table Logger
-- %160000 rows dumped for table Logger
-- %170000 rows dumped for table Logger
-- %180000 rows dumped for table Logger
-- %190000 rows dumped for table Logger
-- %200000 rows dumped for table Logger
-- %210000 rows dumped for table Logger
-- %220000 rows dumped for table Logger
-- %230000 rows dumped for table Logger
root@mcp:~# drizzle -p3307 moocowproductions < mcp.sql
ERROR 1064 (42000) at line 58: 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 '0x654b88,
Pov-Ray 3.1 ' at line 1
If I try to wrap it into one command, I get:
root@mcp:~# drizzledump -p3306 -uroot -Pxyz mcptest --destination-
-- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
--
-- Host: localhost Database: mcptest
-- -------
-- Server version 5.1.41-3ubuntu12.6 (MySQL server)
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 \ ' at line 1b8206d8,
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 '0x7fffab8206d8
root@mcp:~#
It looks like it has to do with using the MySQL equivalent of --hexblob?
Related branches
- Drizzle Merge Team: Pending requested
-
Diff: 121 lines (+16/-13)4 files modifiedclient/drizzledump_data.cc (+2/-2)
client/drizzledump_data.h (+1/-1)
client/drizzledump_mysql.cc (+12/-9)
client/drizzledump_mysql.h (+1/-1)
Changed in drizzle: | |
assignee: | nobody → Andrew Hutchings (linuxjedi) |
importance: | Undecided → High |
milestone: | none → 2010-10-11 |
status: | New → Triaged |
Changed in drizzle: | |
status: | Fix Committed → Fix Released |
Are there blobs/text in that table? I was seeing something similar in my
randgen testing, but I haven't had a chance to analyze it yet.
On Fri, Oct 1, 2010 at 6:20 PM, m00dawg <email address hidden> wrote:
> /bugs.launchpad .net/drizzle/ +bug/653300/ +attachment/ 1664838/ +files/ mcptest. sql.gz /bugs.launchpad .net/bugs/ 653300 '1280x720' ,'Unknown' ,10850x654b88, 'M00Book type=database --destination- port=3307 database= moocowproductio ------- ------- ------- ------- ------- ------- ----- '1280x720' ,'Unknown' ,10850x7fffab82 06d8,'M00Book ,'Owiber' ,'','') ,('2',' 151','Uhh, whoops :) Sorry
> ** Attachment added: "MySQL dump version of the database (data included)"
>
> https:/
>
> --
> Syntax error on inport of a SQL file produced by drizzledump
> https:/
> You received this bug notification because you are a member of Drizzle-
> developers, which is subscribed to Drizzle.
>
> Status in A Lightweight SQL Database for Cloud Infrastructure and Web
> Applications: Triaged
> Status in Drizzle elliott series: Triaged
>
> Bug description:
> After removing my VIEWs from my MySQL schema, I am able to produce a SQL
> file using drizzledump. However, trying to import this file produces:
>
> root@mcp:~# drizzledump -c -p3306 -uroot -pxyz mcptest > mcp.sql
> -- %10000 rows dumped for table Logger
> -- %20000 rows dumped for table Logger
> -- %30000 rows dumped for table Logger
> -- %40000 rows dumped for table Logger
> -- %50000 rows dumped for table Logger
> -- %60000 rows dumped for table Logger
> -- %70000 rows dumped for table Logger
> -- %80000 rows dumped for table Logger
> -- %90000 rows dumped for table Logger
> -- %100000 rows dumped for table Logger
> -- %110000 rows dumped for table Logger
> -- %120000 rows dumped for table Logger
> -- %130000 rows dumped for table Logger
> -- %140000 rows dumped for table Logger
> -- %150000 rows dumped for table Logger
> -- %160000 rows dumped for table Logger
> -- %170000 rows dumped for table Logger
> -- %180000 rows dumped for table Logger
> -- %190000 rows dumped for table Logger
> -- %200000 rows dumped for table Logger
> -- %210000 rows dumped for table Logger
> -- %220000 rows dumped for table Logger
> -- %230000 rows dumped for table Logger
>
> root@mcp:~# drizzle -p3307 moocowproductions < mcp.sql
> ERROR 1064 (42000) at line 58: 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 '0x654b88,
> Running:<BR>\
> Pov-Ray 3.1 ' at line 1
>
>
> If I try to wrap it into one command, I get:
>
> root@mcp:~# drizzledump -p3306 -uroot -Pxyz mcptest
> --destination-
> --destination-
> -- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
> --
> -- Host: localhost Database: mcptest
> -- -------
> -- Server version 5.1.41-3ubuntu12.6 (MySQL server)
>
> 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 \ ' at line 1b8206d8,
> Running:<BR>\
> 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 '0x7fffab8206d8
> ...