MySQL Forums
Forum List  »  GIS

Re: Very long polygon in WKB kills MySQL
Posted by: Mateescu Marcel
Date: March 15, 2006 01:35PM

Hi man, THE BUFFER IS TOO SMALL! You´re sending Megas and the pipe is stuffed! So...

I will help you with it maybe you help me also. You would be as kind as to send me the WKB encoder, won´t you?

So, the solution:
1. use SELECT * FROM a_table INTO OUTFILE '...yourfile.dmp...'
2. take a hex editor like XVI32 and take a look at the goddamn dump file
3. create YOUR OWN dumpfile using WKB data (warning! it´s not stored "properly" but ESCAPED (so a byte that´s 0x00 will actually be two bytes, the characters "\0". Nice ain´t it?)
4. now upload the dumpfile to the CLIENT. I mean the CLIENT is the machine that connects to the DB server (it´s your Webserver, isn´t it?)
5. Execute the LOAD ... command with parameter LOCAL

This junk should work like this.

My best,

Options: ReplyQuote

Written By
January 25, 2006 11:54AM
Re: Very long polygon in WKB kills MySQL
March 15, 2006 01:35PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.