Symptom:
(public)

A short manual to upgrade OTRS 2.2 to OTRS 2.3



As there are some risks in updating from OTRS 2.2 to version 2.3 we
recommend the OTRS
AG's support service for all users of production systems.

We provide this short manual for expert OTRS users and system administrators.
Problem:
(public)
Solution:
(public)

1.) Database Backup


First of all please backup the database. This can either be done using an
phpMyAdmin Interface (if installed, not included) or in the MySQL console
with the following command:

mysqldump [OPTIONS] database [tables]

For a more detailed description please visit:
http://dev.mysql.com/doc/mysql/de/mysqldump.html

2.) Backup of the Config Files


To make sure all specific settings are transferred to the new version,
please save the files Kernel/Config.pm and
Kernel/Config/Files/ZZZAuto.pm in a directory outside the OTRS tree.

3.) Deinstallation of OTRS 2.2


If you installed OTRS version 2.2 using OTRS4win32 installer, please use
the uninstaller.

If you installed OTRS version 2.2 manually, please delete all components
manually and make sure that OTRS, Apache, MySQL, CRONw, and Perl are no
longer to be found on the server.

4.) Installation of OTRS 2.3


To install OTRS version 2.3, please download the recent version of the
Windows Installer from http://otrs.org/download/ and install it
(recommended directory: C:/OTRS). Please make sure to have no
blanks in the directory path.

Now the new OTRS version 2.3 is ready to work on your system! :)

5.) Import of the data backup into OTRS 2.3


Please import your data backup into the new generated MySQL database. This
can either be done using the phpMyAdmin (if installed, not included)
Interface or in the MySQL console.

For more details about the data import using the MySQl console please visit:
http://dev.mysql.com/doc/mysql/en/mysqldump.html

6.) Upgrade database structure


To upgrade the database structures from OTRS 2.2 to version 2.3, OTRS Upgrade
provides Scripts that you find in the folder otrs/scripts/.

1) Update the database changes with (part 1):

  • Change to the MySQL/bin directory

  • MySQL login (with default otrs user): mysql -u otrs -p hot

  • Now type "source PathToOTRS\scripts\DBUpdate-to-2.3.mysql.sql;"

  • Now type "quit"


(Don't worry about the error messages, you can update all previous version
with this script and in the most cases your database has already the most
changes!)

2) Run the migration script:
You must execute the migration script to migrate some data from the old
database structure to the new one.

  • Type "perl PathToOTRS\scripts\DBUpdate-to-2.3.pl"


3) Update the database changes with (part 2):

  • Change to the MySQL/bin directory

  • MySQL login (with default otrs user): mysql -u otrs -p hot

  • Now type "source PathToOTRS\scripts\DBUpdate-to-2.3-post.mysql.sql;"

  • Now type "quit"


Now your database is upgraded to OTRS 2.3.

7.) Copy old Config Files


Please copy the old Config.pm to Kernel/Config.pm and the
old ZZZAuto.pm to Kernel/Config/Files/ZZZAuto.pm.

8.) OTRS 2.3


The only thing left to say now is:

Have fun with OTRS 2.3!!!!


For commercial support with garanteed response times please visit
www.otrs.com or send an e-mail to sales@otrs.com.