[rt-users] new database dump smaller than old one

Aaron Guise aaron at guise.net.nz
Wed Dec 16 01:19:56 EST 2009


Ours reduced by about 1gig.  I am sure it is something to do with the more
efficient storage of binary files in (Binary Datatypes) Instead of
longtext/longblob.

 I noticed also the backup takes less time to run..  All is well and we have
no problems so I feel there is no cause for concern.


On Wed, Dec 16, 2009 at 9:50 AM, David Griffith <dgriffi at cs.csubak.edu>wrote:

>
> I installed RT 3.8.7 on a test server and loaded the database with a dump
> from my production instance of RT (version 3.6.7).  I then went through
> the listed procedures to update the database for 3.8.7.  A dump of the
> resulting database is about 9.5 megabytes whereas the old database dump is
> about 13 megabytes.  I've gone through the new setup and everything seems
> to be in place and functioning correctly.  What could explain this
> decrease in size?  Compression that wasn't done in 3.6.x?
>
>
> --
> David Griffith
> dgriffi at cs.csubak.edu
>
> A: Because it fouls the order in which people normally read text.
> Q: Why is top-posting such a bad thing?
> A: Top-posting.
> Q: What is the most annoying thing in e-mail?
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20091216/f4d97fd0/attachment.htm>


More information about the rt-users mailing list