NetXMS Support Forum

English Support => General Support => Topic started by: lindeamon on August 16, 2011, 08:47:03 AM

Title: db export
Post by: lindeamon on August 16, 2011, 08:47:03 AM
hi,

on my first installation i used embedded sqlite and recently i have transfered to mysql and i use nxdbmgr to import the database and it worked fine.
now i want to export the db to a file but it says that there is a problem with the sqlite schema.how can i do this ?

10x,
lindeamon
Title: Re: db export
Post by: Victor Kirhenshtein on August 16, 2011, 09:17:05 AM
Hi!

What NetXMS version you are using?

Best regards,
Victor
Title: Re: db export
Post by: lindeamon on August 16, 2011, 10:07:09 AM
hello victor,

i have upgraded to the 1.0.12 version.the one u said you will port due to my post on server crashing

10x,
lindeamon
Title: Re: db export
Post by: Victor Kirhenshtein on August 17, 2011, 08:43:29 AM
Try to replace file dbschema_sqlite.sql with attached one. May be file that you have is incorrect.

Best regards,
Victor
Title: Re: db export
Post by: lindeamon on August 17, 2011, 08:56:04 AM
10x
i will give it a try and let u know