Print Page - From 1.013 with sqlite to 1.20 with mysql

Title: From 1.013 with sqlite to 1.20 with mysql
Post by: tivanni on May 10, 2012, 05:04:16 PM

Hi,
i'd like to migrate my netxms from version 1.013 with sqlite to 1.20 with mysql.
To make this, i think of follow this procedure:
1)export sqlite database
2)convert to mysql
3)bind netxms 1.013 with new mysql database
4)upgrade to 1.20

Can this work?Any suggest or esxperiences?Is there a quick way to convert database from sqlite to mysql?
Thank you in advance for help

Title: Re: From 1.013 with sqlite to 1.20 with mysql
Post by: Victor Kirhenshtein on May 15, 2012, 09:53:51 AM

Hi!

This should work. In fact, export data file is an sqlite database, so you can try to create new mysql database and use your SQLite database file as source for nxdbmgr import.

Best regards,
Victor

NetXMS Support Forum

English Support => General Support => Topic started by: tivanni on May 10, 2012, 05:04:16 PM