phpMyAdmin - how big is too big?

[deko]

When importing a previously gzipped dump using phpMyAdmin, the maximum size
allowed for the compressed file is 50mg.

Does anyone know how this translates into database size?

Can I assume a compression ratio of 50%? If so, that would mean I cannot use
phpMyAdmin for backup/restore of databases over 100mg.

Does this sound about right?

[Hans]

"deko" <deko@nospam.com> wrote in message
news:Jqqdnd3yHJyEzeLZnZ2dnUVZ_sidnZ2d@comcast.com. ..

> When importing a previously gzipped dump using phpMyAdmin, the maximum
> size allowed for the compressed file is 50mg.
>
> Does anyone know how this translates into database size?

An average harddrive with 200GB capacity weighs in about 600g, so 50mg would
be 16.7 MB.

>
> Can I assume a compression ratio of 50%? If so, that would mean I cannot
> use phpMyAdmin for backup/restore of databases over 100mg.
>
> Does this sound about right?
>

Yes.
There are settings in php.ini and my.cnf that restrict the maximum file
upload size and the maximum allowed packet size.
If you want larger uploads, modify these settings, or use
[url]http://www.ozerov.de/bigdump.php[/url]

Gr, Hans

[Paul Lautman]

Hans wrote:

> "deko" <deko@nospam.com> wrote in message
> news:Jqqdnd3yHJyEzeLZnZ2dnUVZ_sidnZ2d@comcast.com. ..

>> When importing a previously gzipped dump using phpMyAdmin, the
>> maximum size allowed for the compressed file is 50mg.
>>
>> Does anyone know how this translates into database size?

>
> An average harddrive with 200GB capacity weighs in about 600g, so
> 50mg would be 16.7 MB.

This reminds me of when I was working with a colleague in South Africa on a
Y2K project. Each day we walked from the hotel up a hill to the office. Each
day my colleague complained that his laptop seemed to be getting heavier. I
pointed out that he was receiving loads of emails and documents about the
project and this must have added to the weight :-)

[Jerry Stuckle]

deko wrote:

> When importing a previously gzipped dump using phpMyAdmin, the maximum
> size allowed for the compressed file is 50mg.
>
> Does anyone know how this translates into database size?
>
> Can I assume a compression ratio of 50%? If so, that would mean I
> cannot use phpMyAdmin for backup/restore of databases over 100mg.
>
> Does this sound about right?
>
>

Virtually impossible to say. Compression varies extensively depending on the
actual data.

Text generally compresses better than binary data - but not always! You can
typically get anywhere from 25-85% compression on text. Binary data is harder;
typically -5% (yes, the result can be larger!) to 50% or so.

But there are very big margins in these figures. For instance - I had a binary
file compress over 98% - but it was mostly binary zeros.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[email]jstucklex@attglobal.net[/email]
==================