[rt-users] Change text in tickts using database

[Juanjo]

Yes you are right. Is very dangerous. But i use a adapted script to make
the migration.
I don have the knowledge to do by myself.

I lost some locale data in the migration.

If run this in rtdb database:

 update attachments set content = replace(content, 'u', '*')

I believe that these changes are so located, are not capable by
themselves alter
the overall operation off RT.

For example, all the characters in words on content column  that i change,
and reindexed now appears in the search.

Im only do that on the test rt installation, not in the production
enviroment. Yet :D

2012/10/19 Kevin Falcone <falcone at bestpractical.com>

> If you do run this, please make sure if you report any bugs in the
> future to mention that you did a conversion from mysql to pg and then
> massaged the data by hand.  It'll help us know that much of the data
> shouldn't be trusted.
>
> If I were you, I'd be trying to make the mysql -> pg conversion part
> work without needing the massage afterwards.  That just seems fraught
> with peril.
>



-- 
Un saludo.
Juanjo Corral
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20121021/3d44b77b/attachment.htm>