did you try to install Openfire 3.6.x and let Openfire update the MySQL database? This should work and would be the most easy solution.
If you want to do this manually:
You get the current database version connect to mysql and execute “select * from OFVERSION;” - it should return “openfire 16” and mybe some more rows if you did install plugins.
Look in the openfire_3_6_3/resources/database/upgrade/ directory. There you will find the update scripts 17/openfire_mysql.sql, 18/openfire_mysql.sql, 19/openfire_mysql.sql and 20/openfire_mysql.sql which you can run manually. You need again to connect to mysql, choose the database where you did install Openfire, likely with “use openfire;” and then you can run the scripts with “source …path-to…/17/openfire_mysql.sql;” and so on.
In any case you should make a backup of your database before you try to update it.
RE: did you try to install Openfire 3.6.x and let Openfire update the MySQL database? This should work and would be the most easy solution.
Actually i did install openfire 3.6 and overwrite the old version and the moment i open the web console while prompting database i got an error like problem on tables…
RE: Look in the openfire_3_6_3/resources/database/upgrade/ directory. There you will find the update scripts 17/openfire_mysql.sql, 18/openfire_mysql.sql, 19/openfire_mysql.sql and 20/openfire_mysql.sql which you can run manually.
So it means that ill connect to the old database of openfire 3.5 then go to MSSQL analyzer then run the 17,18,19,20 MSSQL.sql scripts to update it to
OPENFIRE 3.6 database?
im currently using MSSQL server 2000
Updated:
I restore the old database from openfire 3.5 to MSSQL SERVER 2000
Installed Openfire 3.6.x
Heres the screenshot of the error… i also attached the console errors of somekind of upgrading…thanks…