Query about FreeText in OTRS v1.3.1 and also Upgrading questions

We have been happily using OTRS 1.3.1 since 2005 and it has been working flawlessly ever since (I know v1.3.1 is very old but it just works!) . A feature we use is FreeText fields which we fill using a sql statement in a Perl script which is run when a ticket is automatically moved to a certain queue. With OTRS 1.3.1 we can have up 8 FreeText fields and when you zoom in on a ticket all these are displayed on the right of the window. However, when you click on the 'Free Text' option only 4 FreeText fields are presented for editing! I am sure this has been fixed in a later version of OTRS but is it something easily fixed in the present version by editing a file/files? This brings me to thinking about upgrading as our system is old but we only have our working system and we have no backup system that I test a upgrade on. Also, I have inherited the system so I do not know much about it. Question:
From reading the various documents it seems that the process of upgrading OTRS must be done in steps. Am I correct in that I cannot go from version 1.3.1 straight to the present version but must do it in steps. If I am correct what steps must be taken to get up to the current version of OTRS?
Question: Reading the UPGRADING file that came with version 1.3.1, and is present in every subsequent release, one of its points says "Backup everything (database, Kernel/Config.pm, Kernel/Config/GenericAgent.pm, var/*)". I can backup the files and directories mentioned but is there any documentation of how to backup the MySQL database as I have little experience with it? Thanks Paul
participants (1)
-
paul.mcilfatrick@bt.com