Mendix - Database

0
In mendix, i have changed my local database (Built-in-database) to MySQL / MariaDB. I have successfully migrated the database in my local with new Tables has been created in my MySQL local database. But there is no data. But the data is still available in mendix Built-in-database (hsql database). I want the same data to be copied to MySQL database tables. How to do it? could someone guide on the same
asked
2 answers
1

Hi Jagan,


  1. Goto 'Project\deployment\data\Database' Folder.
  2. You can see data,script,properties and log.
  3. Copy the entire database folder and paste in different location.
  4. Open you SQL server and connect with mendix application, Mendix will create all tables automatically in SQL server.
  5. Install DBeaver then Connect to HSQLDB and Connect to SQL Server.
  6. Right-click schema/table, Choose export or transfer data and select SQL server as target.
  7. Use JDBC URL as 'jdbc:hsqldb:file:<DB copied location>'
  8. This process transfer your data.

Hope this will helps!

answered
0

Hi Jagan, this documentation has exactly what you need. Just replace PostgreSQL with MySQL:


https://docs.mendix.com/howto/data-models/migrating-your-mendix-database/

answered