Lost tables in the RT database

Hello!

RT 3.4.1/Debian Sarge box

I lost 2 tables when I started to migrate my RT instance to InnoDB
(my fault, both tables were already in InnoDB and not backuped)

I lost ObjectCustomFields, which seems to be no
problem because I don’t use custom fields in this instance.

And I lost the table “Attributes”. Is there any important information
stored by default? At the moment everything looks okay, with the empty
Attributes table.

regards!

sven

Hello!On Wed, 2007-09-19 at 14:18 +0200, Iounes GARDON /iog .Y wrote:

The table Attributes is used to store users’s preferences.
The table store the “Search - My Tickets” entry (and many others).
A wiki page has been written to repair this entry
(RepairSearches - Request Tracker Wiki). You can use it to
repair all default entries in the table Attributes.
As shown in the wiki, you must have a file /etc/initialdata. This
file is used to populate the database.
Use it to restore your table.

So I looked at initialdata but in my 3.4.1 instance, there are no
entries for this tables. I compared this with my 3.6 installation,
there are enries for the Attributes table in inittialdata.
My conclusion in 3.4.1 the Attributes table is by default empty.
I also tried to save a search definition, this works and now
I have a row in the table.

Many thanks to Iounes for your help!

best regards

sven

Hello,

The table Attributes is used to store users’s preferences.
The table store the “Search - My Tickets” entry (and many others).
A wiki page has been written to repair this entry
(RepairSearches - Request Tracker Wiki). You can use it to
repair all default entries in the table Attributes.
As shown in the wiki, you must have a file /etc/initialdata. This
file is used to populate the database.
Use it to restore your table.

Good luck.

Iounes GARDON