Clean up large data before upgrade

[potion]

I'm upgrading my last (and largest - that's why I've been procrastinating!) Feng Office instance from 1.7.5 to 2.x and want to cleanup the database tables and files before I do.

The biggest user of data is email, with the table fo_mail_datas, and the upload folder that contains all the attachment data.

Simply deleting old or irrelevant emails and their attachments does not clear the records in the database tables (I'm not sure what happens to the attachment in the upload tree).

Are there any tools or utilities that can help?

Denis

[potion]

I managed to clean up some redundant data with SQL:

First, from fo_searchable_objects:

Code: [Select]

DELETE so.*
FROM fo_searchable_objects so,  fo_mail_contents mc
WHERE so.rel_object_manager = "MailContents"
AND so.rel_object_id  = mc.id
AND mc.is_deleted = 1

Then, from both fo_mail_datas and fo_mail_contents:

Code: [Select]

DELETE md.*, mc.*
FROM fo_mail_datas md, fo_mail_contents mc
WHERE md.id = mc.id
AND mc.is_deleted = 1

...and then optimized the tables and reduced the size significantly.

I'm not yet sure if I broke anything, but there don't appear to be any ill effects.

[franponce87]

I am not that sure whether that was a good move as you still have the fo_application_logs table.
I do not know how would these actions work out with this.

Best regards,
Francisco