JIRA Server with HSQL to JIRA Server with MySQL

[Jason Galea]

Hi,

What would be the best way to migrate a JIRA Server 6.3.1 from HSQL to another freshly installed one using MySQL.

I did try a backup and restore but when importing to MySQL I keep getting this error:

java.lang.RuntimeException: org.apache.jasper.JasperException: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:

Database:

        - name:MySQL

        - version:5.6.40

        - minor version:6

        - major version:5

Driver:

        - name:MySQL Connector Java

        - version:mysql-connector-java-5.1.46 ( Revision: 9cc87a48e75c2d2e87c1a293b2862ce651cb256e )

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jiradb.AO_60DB71_RAPIDVIEW' doesn't exist

Any suggestions?

[Danyal Iqbal]

Does the table really exist in the db? MySQL uses case sensitive table names.

• Set lower_case_table_names to have the value '0' in MySQL
• Create a new database in accordance with and retry if the issue is not related to case sensitivty https://confluence.atlassian.com/adminjiraserver073/connecting-jira-applications-to-a-database-861253039.html