Prev | Current Page 122 | Next

Marc Delisle

"Mastering phpMyAdmin 2.11 for Effective MySQL Management"


The default templates are configurable, via the following parameters:
$cfg['Export']['file_template_table'] = '__TABLE__';
$cfg['Export']['file_template_database'] = '__DB__';
$cfg['Export']['file_template_server'] = '__SERVER__';
Compression
To save transmission time and get a smaller export file, phpMyAdmin can compress
to zip, gzip, or bzip2 formats. phpMyAdmin has native support for the zip format,
but the gzip and bzip2 formats work only if the PHP server has been compiled with
the ??“-with-zlib or ??“-with-bz2 configuration option, respectively. The following
parameters control which compression choices are presented in the panel:
$cfg['ZipDump'] = TRUE;
$cfg['GZipDump'] = TRUE;
$cfg['BZipDump'] = TRUE;
A system administrator installing phpMyAdmin for a number of users could choose
to set all these parameters to FALSE so as to avoid the potential overhead incurred
by a lot of users compressing their exports at the same time. This situation usually
causes more overhead than if all users were transmitting their uncompressed files at
the same time.
In older phpMyAdmin versions, the compression file was built in the web server
memory. Some problems caused by this were:
File generation depended on the memory limits assigned to running PHP
scripts.
During the time the file was generated and compressed, no transmission
occurred, so users were inclined to think that the operation was not working
and that something had crashed.


Pages:
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