db upgrade 1.1.4

[victor]

Could you please try this driver?

Best regards,
Victor

---

mysql.ddr

[lindeamon]

ok

i will give it a try and tell you if it worked.

[lindeamon]

hi victor,

to cut the story short i did everything as i mentioned in the last time and everything went fine but service did not came up.running the service from command line told that my db has a version of 232 and the server is compiled for version 240.
i did an upgrade and it failed and the error message said :" sql query failed (table 'business_services' already exists): " and then it writes the sql command: "create table business_services........" and all of it's data.

Best Regards,
Lindeamon

[lindeamon]

hi victor,

i have tried to delete the table mentioned in the former post and failed with other tables like node_links.
fyi

lindeamon

[victor]

Hi!

Looks like database was messed up during all these upgrades. Can you please run

nxdbmgr upgrade -X

(it will ignore errors), and then try to run server. Also, if possible, export and send to me database schema - I'll check it for correctness.

Best regards,
Victor

[lindeamon]

ok victor,

it worked.
what version of the sql.ddr patches do i have to save for now ? the latest one ?

Best Regards,
Lindeamon

[lindeamon]

regarding the schema,is there any quick way to export it without any records ? if it is not possible then i will not be able to send it to you.
but there is something the makes me wonder,after each installation i tried with the different patches you gave me i have restored the databse to the one that worked with v1.1.3 so why would it give me errors ?
maybe i will try to make a clean install and check it.

10x,
lindeamon

[lindeamon]

hi victor,

i found a way to export with no data.here is the v1.1.4 schema

---

netxms_db_export_v1.1.4_no_data.sql

[victor]

@lindeamon said in db upgrade 1.1.4:

what version of the sql.ddr patches do i have to save for now ? the latest one ?

Yes.

Best regards,
Victor