OTRS upgrade 1.2.4 - 1.3.2 RedHat 9 Backing up the MySQL data should not be a problem: you can simply copy the complete MySQL OTRS data directory including all the data (.MYD files) to another directory. You should backup you data on a daily bases: make a cron job for the mysqldump command (see http://dev.mysql.com/doc/mysql/en/mysqldump.html). It's very easy and should not be a problem. I'm not a Linux expert, but this is simple and powerful. I assume you have downloaded the new 1.3.2 OTRS RH8 rpm. 1. stop all services ("service otrs stop") 2. backup everything (I did not need the backup files at all, but you never know....) : OTRS is in /opt/otrs. Copy the complete directory structure (I did this with Midnight Commander (mc) utility) to f.i. /otrs124 3. backup MySQL data (/var/lib/mysql/otrs/*.MYD files) 4. install the new RPM (rpm -ivh --force otrsxxxxxx.rpm) I had to use --force so all the old files were rewritten, when I didn't I got a lot of error messages) 5. update the database changes with: MySQL: cat /opt/otrs/scripts/DBUpdate-to-x.y.mysql.sql | mysql -p -f -u root otrs 6. execute (from /bin !!) /opt/otrs/bin/SetPermissions.sh otrs apache apache apache apache 7. I changed in /etc/sysconfig/otrs the OTRS_DB_RUNNING=1 to =0 because on RH the mysqld check does not work properly 8. restart the services: service httpd restart service mysql start service otrs start this did the job for me :-) regards, Peter -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Philippe Roth Sent: woensdag 15 juni 2005 15:11 To: otrs@otrs.org Subject: [otrs] Please need HELP... Dear All, I sent this problem several times, but no answers.... Pleaaaase.... We need to know how to make an upgrade from a previous version too a more recent. We have installed version 1.3.1 and would like to make the upgrade to 1.3.2 (before version 2.0) We made works and we have a problem when making a queue a sub-queue of an other. The message shown is "Error: Need SystemAddressID! " Our server is under Fedora Core 2. We made backup of the database with # mysqldump --add-drop-table -u root -p otrs otrs-backup.bkp We would like to know what is the correct procedure to make a upgrade? Does anyone have any experience in this??? Please heeeellllppppp..... Many thanks in advance for some light, Philippe Roth _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? =http://www.otrs.de/