Orthanc 1.9.2 restore mySQL database toruble

98 views
Skip to first unread message

Anton Solodovnyk

unread,
May 11, 2021, 5:49:53 PM5/11/21
to Orthanc Users
Good night today I am facing the problem of restoring the mysql index database. After restoring a full dump of the index database (created with mysqldump), it is impossible to add new studies to Orthanc. PROCEDURE orthanc_db.CreateInstance does not exist Please tell me the best way to solve this issue.

Sébastien Jodogne

unread,
May 12, 2021, 1:22:22 AM5/12/21
to Orthanc Users
Hello,

By default, the "mysqldump" tool doesn't archive routines (i.e. stored functions and stored procedures). You should add the "--routines" command-line option to "mysqldump" when generating your dump.

If you are in a hurry, here is the SQL file to manually create the "CreateInstance" procedure that is used by the MySQL plugin 4.0 (this should be the only such function/procedure):

Sébastien-

Anton Solodovnyk

unread,
May 12, 2021, 5:27:36 PM5/12/21
to Orthanc Users
Thank you

среда, 12 мая 2021 г. в 08:22:22 UTC+3, s.jo...@gmail.com:
Reply all
Reply to author
Forward
0 new messages