[rt-users] RT2 database cleanup before rt2->rt3 migration

brianBOFH kerrboy at gmail.com
Thu Sep 23 10:58:00 EDT 2004


RT guru's:

I would like to clean up my RT2 instance in perparation for migration
to RT3.  What is the best way to accomplish this?  My biggest concern
is the Users table.  We have an enormous amount of "SPAM" users and
only about 120 privileged users.  There is also a large amount of dead
Tickets.  Any suggestions are appreciated.

Thanks,
Brian

mysql> use rt2;
Database changed
mysql> select count(*) from Users;
+----------+
| count(*) |
+----------+
|   495693 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from Watchers;
+----------+
| count(*) |
+----------+
|   320520 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from Tickets;
+----------+
| count(*) |
+----------+
|   377596 |
+----------+
1 row in set (26.54 sec)

mysql> select count(*) from Transactions;
+----------+
| count(*) |
+----------+
|  1096803 |
+----------+
1 row in set (0.00 sec)

mysql> select count(id) from Users;
+-----------+
| count(id) |
+-----------+
|    495694 |
+-----------+
1 row in set (0.00 sec)

mysql> select count(id) from Watchers;
+-----------+
| count(id) |
+-----------+
|    320521 |
+-----------+
1 row in set (0.00 sec)

mysql> select count(id) from Tickets;
+-----------+
| count(id) |
+-----------+
|    377597 |
+-----------+
1 row in set (0.00 sec)

mysql> select count(id) from Transactions;
+-----------+
| count(id) |
+-----------+
|   1096804 |
+-----------+
1 row in set (0.00 sec)



More information about the rt-users mailing list