0

I am having a hard time migrating Request Tracker 4.2.8 database from sqlite to mysql.

I've tried the following: http://technolengy.com/articles/rt4-sqlite-woes/

It migrates most of the data, but doesn't migrate Tickets Links (I can't figure out why - i checked and added all the tables) and also it changes the order of some config values in Admin/Tools/System Configuration.

Sorin Ciocoiu
  • 619
  • 1
  • 5
  • 17
  • I've also tried this solution: http://shadow.cat/blog/ian-norton/2013/January/request-tracker-4-assumptions/ . Same result. – Sorin Ciocoiu Jan 31 '17 at 11:07

1 Answers1

1

RT has serializer and importer tools that can help when switching databases. The rt-serializer program writes out your database to disk in a format that can be read by the companion rt-importer program. There are many different options because people use these tools for different use cases, so read through them to see what might apply.

Jim Brandt
  • 611
  • 5
  • 4
  • Thanks! I ran the following: rt-serializer --clone rt-setup-database --action create,schema,acl --dba root --prompt-for-dba-password rt-importer {filename} Everything was imported except the Ticket Links (I'm not sure why, maybe I had a bug on sqlite or something). – Sorin Ciocoiu Feb 01 '17 at 08:33
  • Could be. You can try running rt-validator on your original DB and it might tell you if something isn't quite right with your links or configuration. – Jim Brandt Feb 01 '17 at 13:18
  • Thank You! I used rt-validator --check --verbose --resolve and after that all the data was imported. – Sorin Ciocoiu Feb 02 '17 at 05:47