08-24-2020, 03:28 PM
You shouldn't import it, but just open it. Go to "File" -> "Open Database..." and select "All Files (*)" to see the file. Click on the file name and click "Open" button.
To get to where I was on the screenshot,
1) click on "Browse Data" tab
2) right below you see "Table", select "fileinfo" from the drop-down menu.
3) scroll down, and on any images, double-click on "BLOB"
4) you can then save the file by clicking "Export" button.
Unfortunately I don't see there's any way to auto-export all files. You'll have to export it one-by-one.
If you are familiar with command-line, you can use the command-line version (https://sqlite.org), and run
You'll get a new folder called 'data' with everything in it.
Good luck,
- Rufas
To get to where I was on the screenshot,
1) click on "Browse Data" tab
2) right below you see "Table", select "fileinfo" from the drop-down menu.
3) scroll down, and on any images, double-click on "BLOB"
4) you can then save the file by clicking "Export" button.
Unfortunately I don't see there's any way to auto-export all files. You'll have to export it one-by-one.
If you are familiar with command-line, you can use the command-line version (https://sqlite.org), and run
Code:
sqlite3 Himekoi 'SELECT writefile(filepath,filedata) FROM fileinfo'You'll get a new folder called 'data' with everything in it.
Good luck,
- Rufas