Hi Daniel,
You can't get rid of the table (Review Board will break), but you can have
MySQL optimize the table, which should bring the size down:
OPTIMIZE TABLE diffviewer_filediffdata;
Christian
On Thu, Mar 16, 2017 at 09:00 Daniel Kuecker <dan...@kuecker.net> wrote:
> I recently moved our RB 1.7.27 instance to a 2.5.9 instance. I restored a
> backup of the 1.7.27 db to the 2.5.9 instance and ran rb-site install and
> waited and waited. Everything converted successfully and we are now
> running 2.5.9 (our users love it! yay!)
>
> NOTE: Before the restore, to avoid the InnoDB conversion evolution, I
> manually edited the sql dump, changed the table engines to InnoDB and the
> charset to UTF8 for all tables.
>
> I noticed I still have a diffviewer_filediffdata table that is the same
> size as the original but has zero records. Is that table needed anymore?
> I'd like to get rid of it as it is 28GB in size.
>
> Thanks!
>
> --DK
>
> --
> Supercharge your Review Board with Power Pack:
> https://www.reviewboard.org/powerpack/
> Want us to host Review Board for you? Check out RBCommons:
> https://rbcommons.com/
> Happy user? Let us know! https://www.reviewboard.org/users/
> ---
> You received this message because you are subscribed to the Google Groups
> "reviewboard" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to reviewboard+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
--
Christian Hammond
President/CEO of Beanbag <https://www.beanbaginc.com/>
Makers of Review Board <https://www.reviewboard.org/>
--
Supercharge your Review Board with Power Pack:
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons:
https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
---
You received this message because you are subscribed to the Google Groups
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
