I’‘m looking to upgrade our Wildfire server from 2.6.2 to 3.01. I wanted to inquire about any advice you may have to help with this process as this is a production box. I’'m new to the Wildfire Server so any help/comments are appreciated. My initial thoughts are to back up the embedded-db and conf directories and install the new version.
I don’‘t remember exactly what upgrade required MySQL 5, but I’'m fairly certain it was from 2.6.2 to 3.0. So my recommendation would be to upgrade to the latest stable MySQL version, then upgrade Wildfire.
Make sure that you are using MySQL 4.1.18 or later (5.x recommended) ¹.
¹ Character fields larger than 255 are not supported by versions prior to MySQL 4.1.18. If you cannot upgrade MySQL to the latest version, you will then need to change the database scripts. In particular, replace VARCHAR(1024) with VARCHAR(255) in the resources/database/wildfire_mysql.sql script.
Looks like I will need MySQL 4.1.18 or later…already have MySQL 3.23 database set up…so i will need to backup existing db and wildfire conf.xml files…first upgrade mysql to latest and then wildfire…inserting conf.xml file back in?