Yep. I don't think there are BLOBs (as in binary data) but TEXT is definitely in there.

On Oct 1, 2010, at 6:23 PM, Patrick Crews wrote:

> 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?
>> 
>> 
>> 
> 
> -- 
> 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 direct subscriber
> of the bug.
> 
> 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?
> 
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/drizzle/+bug/653300/+subscribe
>