2. PHPRunner General questions
  3. Saving Blob to File
This topic is locked

Saving Blob to File

 		2/17/2011 12:44:53 PM
PHPRunner General questions
J
 jef3966 author

I have a table that has files stored in it with a file type of blob. There are 452 records with the following fields: id, date, file, filename, status, and comments. I can click on any file listed and it prompts me to open or save. This works fine, but I have a need to export (save) more than 1 file record. What is the easiest way to save blobs to files? Any help is much appreciated!
Sergey Kornilov admin 2/17/2011

I'm afraid you can only do this saving files one by one. There is no way to download and save them all together.
J
 		jef3966 author 2/17/2011

Is there any way to export the blob files from the backend in mysql admin? Thanks for your assistance!
Sergey Kornilov admin 2/17/2011

I guess you can write a PHP script that goes through this table and saves each blob file to some folder on the web server. You can download them all at once then.