Professional Web Applications Themes

phpMyAdmin - how big is too big? - MySQL

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?...

  1. #1

    Default phpMyAdmin - how big is too big?

    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?


    deko Guest

  2. #2

    Default Re: phpMyAdmin - how big is too big?


    "deko" <dekonospam.com> wrote in message
    news:Jqqdnd3yHJyEzeLZnZ2dnUVZ_sidnZ2dcomcast.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


    Hans Guest

  3. #3

    Default Re: phpMyAdmin - how big is too big?

    Hans wrote:
    > "deko" <dekonospam.com> wrote in message
    > news:Jqqdnd3yHJyEzeLZnZ2dnUVZ_sidnZ2dcomcast.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 doents about the
    project and this must have added to the weight :-)


    Paul Lautman Guest

  4. #4

    Default Re: phpMyAdmin - how big is too big?

    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]jstucklexattglobal.net[/email]
    ==================
    Jerry Stuckle Guest

Similar Threads

  1. phpMyAdmin Can't create DBs HELP
    By ACAY in forum PHP Development
    Replies: 1
    Last Post: October 19th, 09:46 AM
  2. PhpMyadmin Help
    By hope@hope.com in forum PHP Development
    Replies: 6
    Last Post: March 23rd, 05:03 AM
  3. Help with phpMyAdmin
    By Gamespy007 in forum Macromedia Dynamic HTML
    Replies: 2
    Last Post: March 16th, 02:27 PM
  4. PHPMyAdmin
    By Didier Caamano in forum PHP Development
    Replies: 13
    Last Post: July 21st, 01:08 AM
  5. phpmyadmin - help please!
    By David Robley in forum PHP Development
    Replies: 0
    Last Post: July 7th, 10:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139