Converting blob entries to external file links

This topic is locked

Converting blob entries to external file links	6/10/2020 6:16:40 AM
PHPRunner General questions
mbintex author Hi at all, made the mistake to define blob fields for documents in a database and now the database is getting too big in my eyes. So for new entries I already only allow uploading files and saving a link in the database with a medium text field - much better for the size of the database. Now I would like to convert old records to the new standard. Task would be: export blob content with filename saved in a second field to a user specific folder (like here: https://forums.mysql.com/read.php?10,370008,370109#msg-370109) change the record with filling a medium textfield with something like `[{"name":"files\/USER\/FILENAME.EXT","usrName":"FILENAME.EXT","size":83991,"type":"application\/pdf","searchStr":"FILENAME,!:sStrEnd"}]` Has anyone done this before and a script for me?

No data yet.