Get Filename from .bin file

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
dozios
Member II

Get Filename from .bin file

Jump to solution

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

1 Solution

Accepted Solutions
afaust
Master

Re: Get Filename from .bin file

Jump to 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").

1 Reply
afaust
Master

Re: Get Filename from .bin file

Jump to 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").