On 29-6-2015 2:26, Jeffrey Pilant wrote: > Joop wrote: >> On 26-6-2015 19:52, Jeffrey Pilant wrote: >>> I am trying to import data from RT 3.8.4 into RT 4.2.10. >>> I first tried to update in place, but that failed. [Ancient version >>> of Ubuntu (9.10, current LTS 14) with ancient Perl and ancient Apache.] >>> I next did a clean install on SUSE (12.2, 64bit), which worked. >>> Now I need to add the old data. >>> I updated the old database by the following steps: >>> make upgrade-database >>> /opt/rt4/etc/upgrade/upgrade-articles >>> /opt/rt4/sbin/rt-validator --check >>> /opt/rt4/sbin/rt-serializer >>> /opt/rt4/sbin/rt-importer <ExportedDataDirectory> >>> >> You can import a mysql export from the old version into the new database >> and then follow the upgrade instruction. >> So: >> - install new system, install RT according to the installation manual if >> you want to check if all is functional also run make initdb. If that >> works, make dropdb, import the old data and following the upgrade >> instructions paying attention to the fact that you're using mysql. My >> memory says that you need some additional steps besides make >> upgrade-database. > The upgrade-articles is the succeeding step I think you are thinking of. > > While I did not do "make dropdb", I did "drop database rt4" in mysql, > followed by "create database rt4", "use rt4", and "source > <old-db-mysqldump>". This let the RT4 tools access the old data, allowing > the upgrade-database and upgrade-articles. Sofar its OK. Your RT instance is usable from here.
> The serializer exported the data to a neutral xml format. I then reset the > database back to the clean-install's version I had previously saved. > > This loaded the old data into the new database, but changed the ticket > numbers. > Why the export, reset, import? There is, sofar as I know, nothing in the upgrade instructions that tells you to do this. Joop