Comment 2 for bug 653300

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:

>
> ** Attachment added: "MySQL dump version of the database (data included)"
>
> https://bugs.launchpad.net/drizzle/+bug/653300/+attachment/1664838/+files/mcptest.sql.gz
>
> --
> Syntax error on inport of a SQL file produced by drizzledump
> https://bugs.launchpad.net/bugs/653300
> 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,'1280x720','Unknown',10850x654b88,'M00Book
> 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-type=database --destination-port=3307
> --destination-database=moocowproductio
> -- 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,'1280x720','Unknown',10850x7fffab8206d8,'M00Book
> 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,'Owiber','',''),('2','151','Uhh, whoops :) Sorry
> dude. I\'ll fix ' at line 1
> root@mcp:~#
>
> It looks like it has to do with using the MySQL equivalent of --hexblob?
>
>
>