How to upload data from MSM database to MySQL database?

Question

MySQL

I have an MSM database, I need to extract data from it and export it to a MySQL database.
I am a noob in MSM, tell me what software to use and how can I solve the problem?

Answer 1

It's easier to a text file, and then from it anywhere.
For example, for a global with one level:

O 51:("c:\users.txt":"W")
U 51
S I=""
F  S I=$O(^USERS(I)) Q:I=""  D
. W $G(^USERS(I)),!
C 51

You can use the standard %GS utility:

>d ^%GS
                    MSM - Global Save Utility
                       20-OCT-15  6:20 PM
Enter output device <HFS>:   Host File Server
File Name >: c:\users.txt
Enter size of save medium (if applicable):
Enter comment for dump header :
Global selector: ^USERS
Global selector: ^
Saving ...
^USERS
Save complete.
>_

All nesting levels will be preserved, but with node names