Yes, but the documentation you provided does NOT address my question. I know where the files are. They are in the DB. I want to get them out of the DB and into the filesystem. These are the 4 biggest tables
- CMS_AttachmentHistory - 800MB
- CMS_ObjectVersionHistory - 2GB
- CMS_VersionHistory - 600MB
- CMS_Attachment - 300MB
We WERE storing the files in the 'Database' with versioning on the media library and attachments, but the DB is getting too large and unweildly, so we've switched the setting to storing the files in the 'file system' and turned versioning off for these two types of objects. https://www.screencast.com/t/MiMie81tP9H Unfortunately, just changing this setting doesn't do anything to the files already in the Database. NEW files are created in the filesystem. Existing files just sit in the DB.
I'm trying the API code from https://devnet.kentico.com/articles/moving-file-storage-from-database-to-file-system, but that just moves the attachments. There are also a bunch of media.file objects in the CMS_ObjectVersionHistory that are NOT present in the filesystem, so I'd like to create files in the media library from the binary field in the CMS_ObjectVersionHistory table.
Here's what one of the media libs looks like:
- you can see the yellow alert symbol showing that the file doesn't exist in the filesystem. However, if I click the green eye symbol, the image loads from the DB just fine. So the file is there, I just need a way to create a copy in the filesystem.