[rt-users] RT 4.2.10: Renumber imported tickets

Jeffrey Pilant jeffrey.pilant at bayer.com
Sun Jun 28 20:26:13 EDT 2015

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.
>- 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.  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.

I need the old numbers.  How can I get the back to what they were?

The information contained in this e-mail is for the exclusive use of the 
intended recipient(s) and may be confidential, proprietary, and/or 
legally privileged.  Inadvertent disclosure of this message does not 
constitute a waiver of any privilege.  If you receive this message in 
error, please do not directly or indirectly use, print, copy, forward,
or disclose any part of this message.  Please also delete this e-mail 
and all copies and notify the sender.  Thank you. 

For alternate languages please go to http://bayerdisclaimer.bayerweb.com

More information about the rt-users mailing list