The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

bzip compression and phpMyAdmin

Discussion in 'Database Discussions' started by dwinans, Aug 3, 2009.

  1. dwinans

    dwinans Member
    PartnerNOC

    Joined:
    Jan 23, 2009
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    I noticed that bzip compression is not an option in the phpMyAdmin Export function. gzip and zip are there. These are usually enabled via these 3 options in config.inc.php

    $cfg['ZipDump'] = TRUE;
    $cfg['GZipDump'] = TRUE;
    $cfg['BZipDump'] = TRUE;

    I took a look at
    /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php

    I didn't see any of these options enabled in that file, however gzip and zip show up in phpMyAdmin so they have to be enabled somewhere. bzip has been enabled in PHP on our servers.

    So the question is how can we get bzip compression enabled? Do we just need to add the "$cfg['BZipDump'] = TRUE;" line into the config.inc.php or is there more to it? Why would zip and gzip be showing up, but not bzip?
     
  2. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    You could update the configuration for Cpanel's phpMyAdmin installation
    but an issue you will likely run into is that Cpanel will overwrite the
    configuration whenever Cpanel is updated.

    The same issue exists with Cpanel's copy of SquirrelMail which could
    have a lot of extra themes and options added available for Squirrelmail
    except that Cpanel overwrites the config with every update.

    You can set the config files for these third party applications to
    immutable (chattr +i) but I have found that causes more problems
    that it solves sometimes with these items so on our servers, we
    installed our own separate installations of phpMyAdmin and Squirrelmail
    with better configuration options of our own choosing deployed on
    wildcard subdomains available to every domain on the server:

    http://mysql.* = Our phpMyAdmin installation

    http://mail.* = Our Squirrelmail installation

    This solution works pretty well and specifically allows us to always have
    the newest and latest versions of these applications usually well ahead
    of Cpanel including the same updates although you might want to go
    ahead and also contact Cpanel directly and make a request to update
    to allow for custom configurations of the included 3rd party applications
    or perhaps go ahead and enable options like the Bzip2 you mentioned by default.
     

Share This Page