View source for Migrate notes from MySQL database

From Opentaps Wiki

← Migrate notes from MySQL database

You do not have permission to edit this page, for the following reasons:

• The action you have requested is limited to users in the group: Users.
• This page has been protected to prevent editing or other actions.

---

You can view and copy the source of this page.

== Migrate notes from MySQL database == Opentaps2 build produces special command-line utility notesconv.jar that can be found in modules/notes/notesconv/target. You can transfer your notes to Mongo database with it in a minute. Use --help to get usage info. <pre> xxx:~/git/opentaps-2/modules/notes/notesconv/target$ java -jar notesconv.jar --help usage: java -jar notesconv.jar [-d] [-h] [-m <arg>] [-p <arg>] [-s <arg>] [-u <arg>] -d,--dry-run Output to the screen w/o modifying MongoDB -h,--help Print available options -m,--mongo <arg> Mongo URI. Default: mongodb://localhost -p,--password <arg> A password to access source database -s,--source <arg> Source database URL in JDBC format -u,--username <arg> An username to access source database </pre> With default settings and databases running on local computer the command line would be as the following: <pre> java -jar notesconv.jar -s jdbc:mysql://127.0.0.1/opentaps2 -u opentaps -p opentaps </pre> Use --dry-run to test.

Return to Migrate notes from MySQL database.