[rt-users] Export, import and purge tickets?

Ruslan Zakirov ruz at bestpractical.com
Tue Jul 3 13:01:44 EDT 2012

On Fri, Jun 29, 2012 at 10:08 AM, Stefan Stefanov <ststefanov at gmail.com> wrote:
> Hello
> Is there any tool to export data for selected tickets (for example in
> mysqldump format file) and after successful export delete all data for
> these tickets from the database?
> This way it would be easy to create backup for old or unnecessary
> tickets, shred them and clean up database. If some of them will be
> needed in the future their data could be imported back from the dump
> file.

Shredder creates a SQL dump file that you can use to restore data. However,
restoring files in a wrong order, skipping some backups or after some changes
can result in inconsistent database. Where inconsistent means that DB can be
incomplete as you didn't restore everything or the current state of the DB
doesn't match state when data was deleted.

It may work, but sometimes would need maintenance on restore.

> --
> Stefan Stefanov

Best regards, Ruslan.

More information about the rt-users mailing list