Hi,
I currently have a production environment otrs-3.2.9-01 installed on a CentOS 5.9 release and MySQL 5.0.95 database.
I know from viewtopic.php?f=53&t=22762 that OTRS cannot be updated to the 3.3.x version due to the Perl 5.10.0 requirements.
These are the details of my present system:
[root@x-otrs ~]# cat /etc/redhat-release
CentOS release 5.9 (Final)
[root@x-otrs ~]# uname -a
Linux x-otrs.iks.local 2.6.18-348.12.1.el5 #1 SMP Wed Jul 10 05:28:41 EDT 2013 x86_64 x86_64 x86_64 GNU/Linux
[root@x-otrs ~]# rpm -qa | grep mysql
libdbi-dbd-mysql-0.8.1a-1.2.2
mysql-connector-odbc-3.51.26r1127-2.el5
mysql-server-5.0.95-5.el5_9
php-mysql-5.1.6-40.el5_9
mysql-5.0.95-5.el5_9
mysql-5.0.95-5.el5_9
[root@x-otrs ~]# rpm -qa | grep otrs
otrs-3.2.9-01
I try to write down the possible migration steps from my current server to a new CentOS 6.4 server with MySQL 5.6.
Here [old.otrs] is my present system (based on CentOS 5) and [new.otrs] is my new system (based on CentOS 6)
1. update OTRS 3.2.9 on [old.otrs] to OTRS 3.2.12 ... since OTRS 3.2.9 version is not compatible with MySQL 5.6
2. install a pretty new system [new.otrs] based on CentOS 6.4 x64, MySQL 5.6 and OTRS 3.2.12
3. backup the database and the article folders (/opt/otrs/var/...) on [old.otrs]
4. restore the backed up stuff on the [new.otrs] system (skipping the OTRS binaries) <<<< I AM NOT SURE ABOUT HOW I CAN DO THAT
5. update the [new.system] to OTRS 3.3.1 (or last available 3.3.x version).
Do you think that this procedure may work?
I think that the critical point is #4.
- MySQL db 5.0.95 can be imported directly on a MySQL 5.6 ?
- I store (by SysConfig) all attachments, tickets and articles on the fs... is it safe to cut and paste that folder from [old.system] to [new.system] ?
Does anyone has already performed this kind of migration?
Any issue or problem found?
Thank you in advance!
Giulio
CentOS 5.x >> CentOS 6.x
Moderator: crythias
-
- Znuny wizard
- Posts: 392
- Joined: 30 Dec 2010, 14:35
- Znuny Version: 6.0.x and 5.0.x
- Real Name: Giulio Soleni
- Company: IKS srl
CentOS 5.x >> CentOS 6.x
OTRS 6.0.x on CentOS 7.x with MariaDB 10.2.x database connected to an Active Directory for Agents and Customers.
ITSM and FAQ modules installed.
ITSM and FAQ modules installed.