[Solved] Question: How to move data from old MYSQL persistence to new JDBC persistence with both databases in same MariaDB instance?

Add-ons Persistence Services
, ,
3

Hi Björn,
thanks for your reply. Even though I used the MYSQL Binding I already had a MariaDB running underneath and both of my databases are running in the same MariaDB instance. I fear that migrating the data with mysqldump won’t work as the in the old database the Item Weather_Condition is stored in different tables and in the old table has the data type e.g. VARCHAR (20000) and the new table VARCHAR (4096) - or it could be int versus long int.
And what I do not know is if can simply dump the old table with into the new table when the old one has a different data type …

I will check your given link and see if I find the answer there!!!

EDIT:
Your links only showed complete database migrations. I search the web and found this:

INSERT INTO dest_database.destination_table (DestColumn_1, DestColumn_2) SELECT SourceColumn_1, SourceColumn_2 FROM source_database.source_table;

This is what I intend to do but the command does not work :frowning:

Thank you for responding!!!