would probably be very dependent on the data within the database. if it's a lot of text data, then very compressable, as text typically compresses nicely. if you store a bunch of binary data (images or something), then probably not as much...
tar your mysql dir and gzip it, or gzip -9 or bzip2 if you're looking for more compression. test it out. -tcl. On Sun, 17 Feb 2002, George Labuschagne wrote: > Hi list, > > How compressible is a typical MySQL database? Is this more dependent on > the type of columns used i.e. a lot of text columns as opposed to a lot > of columns containing integer values? > > The uncompressed size of the database is in the region of about 800-MB. > Also will it suffice to only compress the specific sub-directory > pertaining to the relevant database below /mysql/ ? > > George > mysql, sql, query > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php