Migration from H2 database to mysql

[Jonathan Van Overmeir]

Hello,

I'm trying to setup our production server with a separate mysql database, but can't seems to make the migration from H2 db working.

If I migrate to H2 on the new server, everything works fine. If I try to import the data during the initial launch, I have a "jira has already been set up' message. If I try to 'restore system' after the re-import from H2, I have the following errror :

Unexpected error occurred during import: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:OSPropertyNumber][id,10433][value,9223372036854775807] (SQL Exception while executing the following:INSERT INTO propertynumber (ID, propertyvalue) VALUES (?, ?) (Data truncation: Out of range value for column 'propertyvalue' at row 1))

I've re-read multiples times the documentation but can't make anything works, except for H2 database.

[Moses Thomas · Accepted solution]

@Jonathan Van Overmeir  It looks like you have ran into such  issue, Unable to Restore Data Backup due to 'Out of range value for column 

You would need to  do it this way in the above link.

Kind regards,

Mo