Comment 4 for bug 653300
Revision history for this message
| m00dawg (tim-moocowproductions) wrote Re: [Bug 653300] Re: Syntax error on inport of a SQL file produced by drizzledump | #4 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
513534c
demo site
(Get the code!)
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:/
>>
>> --
>> 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
>> 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:/
> 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,
> 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?
>
> To unsubscribe from this bug, go to:
> https:/
>