Get Filename from .bin file

[dozios]

Hi there.
For some reason we are unable to boot Alfredo but we have all the content (in bin format) and a dB backup.
So the main idea is trying to recover the file properties from the DB knowing the bin name (file system).
Could you suggest any query or any tool to do that?
Thank you

[afaust · Accepted solution]

You can find the *.bin files referenced in the alf_content_url table. This table can be joined with alf_content_data, alf_node_properties and alf_node to find the node which referenced a specific *.bin file. For joining alf_content_data with alf_node_properties you need to join the content data ID on the long_value column for entries with actual_type_n = 21 (that constant stands for "content data with ID").