I have already installed mysql and captured the data?

Carlos Areco

unread,

Aug 3, 2022, 8:32:57 AM8/3/22

to Orthanc Users

Good morning, how do I obtain the data of my patient and the series with orthanc? I am new and I have already installed mysql and captured the data, thanks

carlos areco

unread,

Aug 5, 2022, 10:18:21 PM8/5/22

to Orthanc Users

Good evening, I have patient data and I need to recover their index, which is 24GB and the database is 6TB. How can I see the studies, since the index is corrupted? what is the best solution to view or migrate to mysql please
Thank you

Tran Phong

unread,

Aug 5, 2022, 11:18:37 PM8/5/22

to carlos areco, Orthanc Users

Hi,

I encountered such that issue of corrupted sqlite index. I tried to fix it by command line. However that does not resolve the whole problem. To migrate it to mysql, you can install another orthanc running mysql plugin, then move your existing dicom files to it by either c-store, or rest api

--
You received this message because you are subscribed to the Google Groups "Orthanc Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orthanc-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orthanc-users/12f90b66-c12f-4835-b3b0-be874374c237n%40googlegroups.com.

Sébastien Jodogne

unread,

Dec 22, 2022, 11:57:16 AM12/22/22

to Orthanc Users

Hello,

On Saturday, August 6, 2022 at 4:18:21 AM UTC+2 universoinf...@gmail.com wrote:

I have patient data and I need to recover their index, which is 24GB and the database is 6TB. How can I see the studies, since the index is corrupted? what is the best solution to view or migrate to mysql please

The best solution is to run the "ImportDicomFiles.py" sample script to store the files into a fresh instance of Orthanc, as described here:

https://book.orthanc-server.com/users/replication.html#direct-access-to-the-filesystem

Good morning, how do I obtain the data of my patient and the series with orthanc? I am new and I have already installed mysql and captured the data, thanks

If the MySQL storage area plugin was used, you can run a "SELECT content FROM StorageArea" to retrieve the DICOM files. Otherwise, check out the link above about "Direct access to the filesystem".