On Fri, Jun 29, 2012 at 10:08 AM, Stefan Stefanov ststefa...@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.
