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

2009-12-15 Thread David Griffith

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
dgri...@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: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


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

2009-12-15 Thread Aaron Guise
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 dgri...@cs.csubak.eduwrote:


 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
 dgri...@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: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com