Migrating HSQLDB to MySQL

[Andrey]

Hi,

I have a issue with migrating HSQLDB to MySQL. I try to migrate it via your instruction

https://confluence.atlassian.com/display/DOC/Migrating+from+HSQLDB+to+MySQL

But migration toolkit return empty SQL file.  I copied DB from /var/atlassian/application-data/jira/database 2 files:

jiradb.properties and jiradb.script

After finishing all steps from instructions I got empty file. Here is log file:

--------------------------------------------------------------------------------
-- MySQL Migration Toolkit Report --
-- --
-- Title: Summary Of The Migration Process --
-- Date: 2014-12-16 11:05 --
--------------------------------------------------------------------------------

1. Schema Migration
-------------------

Number of migrated schemata: 1

Schema Name: PUBLIC
- Tables: 0
- Views: 0
- Routines: 0
- Routine Groups: 0
- Synonyms: 0
- Structured Types: 0
- Sequences: 0

Details:

- Tables
- Views
- Routines
- Routine Groups
- Synonyms
- Structured Types
- Sequences

2. Data Bulk Transfer
---------------------

End of report.
--------------------------------------------------------------------------------

[Nic Brough -Adaptavist- · Accepted solution]

Is there a reason you are not using "export to xml" in your HSQL installation, and then "import from xml" in your MySQL installation?  It's easier, safer and supported by Atlassian...