Move blob

[howster_78]

I have a table in a database that is running out of control due to two blob-fields getting too big. These are one tif and one pdffile.
Now I need get those out of there, and put them into a directory.
What is the easiest way to do this?
It would be nice to create a script that just dumps the files into a directory with the id from the table as name, 32455.pdf.

Thanks for any tips

[MarkR]

You could ask your database admin to move those tables containing those blobs into their own directory or on a different filesystem- then you could continue to use blobs.

I am assuming that you already have those blobs in a table containing little or nothing else (besides a key of course) - if not, consider moving them out (You can use joins to replicate the queries you previously used, or create a view).

Because in most databases you can't place different columns from the same table on a different filesystem / device.

But some databases use separate storage for blobs. Consult your DBA.

Extracing the blobs is of course feasible, but you'll have to write a script (Either database script e.g. some dialect of SQL stored procedure or PHP) to do so.

Mark

[howster_78]

I was thinking of creating a php-script.
Not sure how the process with our DBA would be, as they all need to get new names, and the table would be around 10 GB. So I am looking into making an sql-query to the database on the remote server, upload the two different files, renaming them and store them in a directory at my local server.

Thanks for any tips