Exporting Structure and Data - Mastering phpMyAdmin 2.11 for Effective MySQL Management - page 132

User-Specific Save Directories
We can use the special string, %u , in the $cfg['SaveDir'] parameter. This string
will be replaced by the logged-in user name. For example, using:
$cfg['SaveDir'] = './save_dir/%u';
would give us the on-screen choice Save on server in ./save_dir/marc/ directory .
These directories (one per potential user) must exist and must bear the proper
permissions, as seen in the previous section.
Memory Limits
Generating an export file uses a certain amount of memory, depending on the size
of the tables and on the chosen options. The $cfg['MemoryLimit'] parameter can
contain a limit—in bytes—for the amount of memory used by the PHP script that
is running. By default, the parameter is set to 0, meaning that there is no limit. Note
that, if PHP has its safe mode activated, this memory limit has no effect.
Summary
In this chapter, we examined the various ways to trigger an export: from the
Database view, the Table view, or a results page. We also listed the various available
export formats, their options, the possibility of compressing the export file, and the
various places it might be sent.