Search code examples
mysqlsqlinto-outfile

Unload images from MySQL to disk

I have images stored in MySQL as blobs (i know it's wrong). And there are many of them. Is there any fast way to drop them all on disk, like SELECT .. INTO OUTFILE, but to many files insted of one? Or the only way is writing a script that will iterate over rows and save images?

Solution

  • Since you want them to be saved into different files on the disk you'll have to go for a script.