Re: Very long polygon in WKB kills MySQL

[Mateescu Marcel]

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,
Marcel