[rt-users] RT 4.2.10: Renumber imported tickets
jvdwege at xs4all.nl
Mon Jun 29 02:43:44 EDT 2015
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/sbin/rt-validator --check
>>> /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.
>> - 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
> 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.
More information about the rt-users