 |
 |
Can somebody here help me with the MySQL dump syntax? On a more technical note, I am in the process of enhancing my Getting Started With XML workshop: 1. http://infomotions.com/musings/getting-started/LAMP.txt 2. http://infomotions.com/musings/getting-started/shining.txt In the most techno-weenie section, the second one above, I outline how to use LAMP (Linux, Apache, MySQL, Perl) technologies to do XML stuff. In the MySQL section I want to illustrate how to dump blob data from a table into a file, but my illustration doesn't work because the dumped data is escaped (I think). More specifically, I have a MySQL table where one of the fields is a blob. The field contains JPEG data. I want to use this command to dump this blob to a file and then display the image in a JPEG reader: SELECT image INTO DUMPFILE '34.jpeg' FROM waters WHERE water_id = 34 MySQL does dump the file, but the file (34.jpeg) is unreadable. I know the data in the field is valid, because I use it and another other data to implement my online water collection: http://infomotions.com/water/ How do I modify the INTO DUMPFILE clause to make sure the dumped file is readable? -- Eric Lease Morgan