Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From: Tim Watts <tw@dionic.net>
Newsgroups: comp.databases.mysql
Subject: Re: Can MySql database store images?
Followup-To: comp.databases.mysql
Date: Mon, 25 Apr 2011 08:59:34 +0100
Organization: A noiseless patient Spider
Lines: 23
Message-ID: <68mf88-4l5.ln1@squidward.dionic.net>
References: <npqdnTD4r-AUWi7QnZ2dnUVZ5qudnZ2d@giganews.com> <ip15se$33s$1@dont-email.me> <55md88-7pb.ln1@squidward.dionic.net> <ip1c0d$dde$1@dont-email.me> <ip21sn$cb8$1@dont-email.me> <ip23aj$v3q$2@dont-email.me> <ip361h$ml9$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 7Bit
Injection-Info: mx03.eternal-september.org; posting-host="6oIlEBqCjOm0MjsSUEk5CA"; logging-data="2962"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1+mriy+Dq8cfcrOW7xzLB5ci2/tBiFyoyA="
User-Agent: KNode/4.4.6
Cancel-Lock: sha1:58XoWRk/1i8Xcewg9SlSKw7xQcA=
Xref: x330-a1.tempe.blueboxinc.net comp.databases.mysql:645

Norman Peelman wrote:


> 
>    My current setup includes a db with approx 460 images (I know, not
> huge) with a mixture of file formats (.jpg .png .gif) with an average
> size of 5393kb (again not huge, all images are 10240kb or less).
> 
>    The SQL dump file for this entire db is 29.8MB and the resulting .zip
> file is 1.7MB.
> 

I'm intrigued - you have 460 * 5.3MB of images which is around 2.2GB and yet 
your DB dump is 29.8MB and whilst I expect SQL text to zip well, I wouldn't 
expect already lossy-ly compressed image data to zip well.

Are you sure the images are being included in the dumps?

Cheers

Tim

-- 
Tim Watts