[rt-users] 2.0.9 bogs with >10K tickets

[Darren Nickerson]

Christian,

No guarantees here - please backup your database before trying this. Dropping a
database really sends it to bit-heaven.

The post I was thinking of was:

http://lists.fsck.com/pipermail/rt-users/2001-December/005796.html

so:

	mysqldump -c -t rt2 > rt2.sqldump (dumps the data)
	mysqldump -d rt2 > rt2.sqlschema (dumps only the schema)

then you have to do:

	mysqladmin drop rt2 (drop the database)
	mysqladmin create rt2 (creates a new, empty one)

Then you need to import the SQL schemas from a new RT distribution, which give
you all the jazzy new indices etc:

	cd rt-2-0-x/etc
	mysql rt2 < schema.mysql (sets up the RT schemas)

and finally re-import your data:

	mysql rt2  < rt2.sqlschema
	mysql rt2  < rt2.sqldump

(with whatever usernames and passwords you have specified in each case using the -p flags if appropriate).

Hope this helps!

-Darren