Prev | Current Page 121 | Next

Marc Delisle

"Mastering phpMyAdmin 2.11 for Effective MySQL Management"


The Save as file Sub-Panel
In the previous examples, the results of the export operation were displayed
on-screen, and of course, no compression was made on the data. We can choose to
transmit the export file via HTTP by checking the Save as file checkbox. This triggers
a Save dialog into the browser, which ultimately saves the file on our local station:
File Name Template
The name of the proposed file will obey the File name template. In this template, we
can use the special __SERVER__, __DB__ and __TABLE__ placeholders, which will
be replaced by the current server, database or table name (for a single-table export).
Note that there are two underscore characters before and after the words. We can
also use any special character from the PHP strftime function; this is useful for
generating an export file based on the current date or hour. Finally, we can put any
other string of characters (not part of the strftime special characters), which will be
used literally. The file extension is generated according to the type of export. In this
case, it will be .sql. Here are some examples for the template:
__DB__ would generate marc_book.sql
__DB__-%Y%m%d gives marc_book-20071206.sql
???
??? ???
Exporting Structure and Data
[ 124 ]
The remember template option, when activated, stores the entered template settings
into cookies (for database, table, or server exports) and brings them back the next
time we use the same kind of export.


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