OTRS supports PostgreSQL and MySQL databases. I'm using PostgreSQL 9.1 for my OTRS 3.2 but I want to migrate to MySQL 5.5. Is this possible? How?
Asked
Active
Viewed 1,833 times
1 Answers
0
OK, after more research I found this question. So this is what I did:
The Server is a Debian 7 server. I connected from Windows 7.
- Installed ODBC PostreSQL driver (described here)
- Installed MySQL Workbench
- Connected to the server using PuTTY
- Added tunnels to the SSH connection for port 3306 (MySQL) and port 5432 (PostgreSQL) so I can access both server daemons from remote in a secure way
- Setted up the ODBC connection in Windows (using PostgreSQL Unicode)
- Started the Migration Wizard in MySQL Workbench (described here)
- After data migration is completed, I changed the DB settings in /etc/otrs/database.pm
- Restarted Apache to apply changes
- Tried it - worked!
Only problem at the moment is, that umlauts (üöäß) doesn't get correctly imported from mail.
