export.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * @todo    too much die here, or?
   5  * @version $Id$
   6  * @package phpMyAdmin
   7  */
   8
   9 /**
  10  * Get the variables sent or posted to this script and a core script
  11  */
  12 require_once './libraries/common.inc.php';
  13 require_once './libraries/zip.lib.php';
  14 require_once './libraries/plugin_interface.lib.php';
  15
  16 PMA_checkParameters(array('what', 'export_type'));
  17
  18 // Scan plugins
  19 $export_list = PMA_getPlugins('./libraries/export/', array('export_type' => $export_type, 'single_table' => isset($single_table)));
  20
  21 // Backward compatbility
  22 $type = $what;
  23
  24 // Check export type
  25 if (!isset($export_list[$type])) {
  26     die('Bad type!');
  27 }
  28
  29 /**
  30  * valid compression methods
  31  */
  32 $compression_methods = array(
  33     'zip',
  34     'gzip',
  35     'bzip',
  36 );
  37
  38 /**
  39  * init and variable checking
  40  */
  41 $compression = false;
  42 $onserver = false;
  43 $save_on_server = false;
  44 $buffer_needed = false;
  45 if (empty($_REQUEST['asfile'])) {
  46     $asfile = false;
  47 } else {
  48     $asfile = true;
  49     if (in_array($_REQUEST['compression'], $compression_methods)) {
  50         $compression = $_REQUEST['compression'];
  51         $buffer_needed = true;
  52     }
  53     if (!empty($_REQUEST['onserver'])) {
  54         $onserver = $_REQUEST['onserver'];
  55         // Will we save dump on server?
  56         $save_on_server = ! empty($cfg['SaveDir']) && $onserver;
  57     }
  58 }
  59
  60 // Does export require to be into file?
  61 if (isset($export_list[$type]['force_file']) && ! $asfile) {
  62     $message = PMA_Message::error(__('Selected export type has to be saved in file!'));
  63     $GLOBALS['js_include'][] = 'functions.js';
  64     require_once './libraries/header.inc.php';
  65     if ($export_type == 'server') {
  66         $active_page = 'server_export.php';
  67         require './server_export.php';
  68     } elseif ($export_type == 'database') {
  69         $active_page = 'db_export.php';
  70         require './db_export.php';
  71     } else {
  72         $active_page = 'tbl_export.php';
  73         require './tbl_export.php';
  74     }
  75     exit();
  76 }
  77
  78 // Generate error url and check for needed variables
  79 if ($export_type == 'server') {
  80     $err_url = 'server_export.php?' . PMA_generate_common_url();
  81 } elseif ($export_type == 'database' && strlen($db)) {
  82     $err_url = 'db_export.php?' . PMA_generate_common_url($db);
  83     // Check if we have something to export
  84     if (isset($table_select)) {
  85         $tables = $table_select;
  86     } else {
  87         $tables = array();
  88     }
  89 } elseif ($export_type == 'table' && strlen($db) && strlen($table)) {
  90     $err_url = 'tbl_export.php?' . PMA_generate_common_url($db, $table);
  91 } else {
  92     die('Bad parameters!');
  93 }
  94
  95 // Get the functions specific to the export type
  96 require './libraries/export/' . PMA_securePath($type) . '.php';
  97
  98 /**
  99  * Increase time limit for script execution and initializes some variables
 100  */
 101 @set_time_limit($cfg['ExecTimeLimit']);
 102 if (!empty($cfg['MemoryLimit'])) {
 103     @ini_set('memory_limit', $cfg['MemoryLimit']);
 104 }
 105
 106 // Start with empty buffer
 107 $dump_buffer = '';
 108 $dump_buffer_len = 0;
 109
 110 // We send fake headers to avoid browser timeout when buffering
 111 $time_start = time();
 112
 113
 114 /**
 115  * Output handler for all exports, if needed buffering, it stores data into
 116  * $dump_buffer, otherwise it prints thems out.
 117  *
 118  * @param   string  the insert statement
 119  *
 120  * @return  bool    Whether output suceeded
 121  */
 122 function PMA_exportOutputHandler($line)
 123 {
 124     global $time_start, $dump_buffer, $dump_buffer_len, $save_filename;
 125
 126     // Kanji encoding convert feature
 127     if ($GLOBALS['output_kanji_conversion']) {
 128         $line = PMA_kanji_str_conv($line, $GLOBALS['knjenc'], isset($GLOBALS['xkana']) ? $GLOBALS['xkana'] : '');
 129     }
 130     // If we have to buffer data, we will perform everything at once at the end
 131     if ($GLOBALS['buffer_needed']) {
 132
 133         $dump_buffer .= $line;
 134         if ($GLOBALS['onfly_compression']) {
 135
 136             $dump_buffer_len += strlen($line);
 137
 138             if ($dump_buffer_len > $GLOBALS['memory_limit']) {
 139                 if ($GLOBALS['output_charset_conversion']) {
 140                     $dump_buffer = PMA_convert_string($GLOBALS['charset'], $GLOBALS['charset_of_file'], $dump_buffer);
 141                 }
 142                 // as bzipped
 143                 if ($GLOBALS['compression'] == 'bzip'  && @function_exists('bzcompress')) {
 144                     $dump_buffer = bzcompress($dump_buffer);
 145                 }
 146                 // as a gzipped file
 147                 elseif ($GLOBALS['compression'] == 'gzip' && @function_exists('gzencode')) {
 148                     // without the optional parameter level because it bug
 149                     $dump_buffer = gzencode($dump_buffer);
 150                 }
 151                 if ($GLOBALS['save_on_server']) {
 152                     $write_result = @fwrite($GLOBALS['file_handle'], $dump_buffer);
 153                     if (!$write_result || ($write_result != strlen($dump_buffer))) {
 154                         $GLOBALS['message'] = PMA_Message::error(__('Insufficient space to save the file %s.'));
 155                         $GLOBALS['message']->addParam($save_filename);
 156                         return false;
 157                     }
 158                 } else {
 159                     echo $dump_buffer;
 160                 }
 161                 $dump_buffer = '';
 162                 $dump_buffer_len = 0;
 163             }
 164         } else {
 165             $time_now = time();
 166             if ($time_start >= $time_now + 30) {
 167                 $time_start = $time_now;
 168                 header('X-pmaPing: Pong');
 169             } // end if
 170         }
 171     } else {
 172         if ($GLOBALS['asfile']) {
 173             if ($GLOBALS['output_charset_conversion']) {
 174                 $line = PMA_convert_string($GLOBALS['charset'], $GLOBALS['charset_of_file'], $line);
 175             }
 176             if ($GLOBALS['save_on_server'] && strlen($line) > 0) {
 177                 $write_result = @fwrite($GLOBALS['file_handle'], $line);
 178                 if (!$write_result || ($write_result != strlen($line))) {
 179                     $GLOBALS['message'] = PMA_Message::error(__('Insufficient space to save the file %s.'));
 180                     $GLOBALS['message']->addParam($save_filename);
 181                     return false;
 182                 }
 183                 $time_now = time();
 184                 if ($time_start >= $time_now + 30) {
 185                     $time_start = $time_now;
 186                     header('X-pmaPing: Pong');
 187                 } // end if
 188             } else {
 189                 // We export as file - output normally
 190                 echo $line;
 191             }
 192         } else {
 193             // We export as html - replace special chars
 194             echo htmlspecialchars($line);
 195         }
 196     }
 197     return true;
 198 } // end of the 'PMA_exportOutputHandler()' function
 199
 200 // Defines the default <CR><LF> format. For SQL always use \n as MySQL wants this on all platforms.
 201 if ($what == 'sql') {
 202     $crlf = "\n";
 203 } else {
 204     $crlf = PMA_whichCrlf();
 205 }
 206
 207 $output_kanji_conversion = function_exists('PMA_kanji_str_conv') && $type != 'xls';
 208
 209 // Do we need to convert charset?
 210 $output_charset_conversion = $asfile && $cfg['AllowAnywhereRecoding']
 211     && isset($charset_of_file) && $charset_of_file != $charset
 212     && $type != 'xls';
 213
 214 // Use on the fly compression?
 215 $onfly_compression = $GLOBALS['cfg']['CompressOnFly'] && ($compression == 'gzip' || $compression == 'bzip');
 216 if ($onfly_compression) {
 217     $memory_limit = trim(@ini_get('memory_limit'));
 218     // 2 MB as default
 219     if (empty($memory_limit)) {
 220         $memory_limit = 2 * 1024 * 1024;
 221     }
 222
 223     if (strtolower(substr($memory_limit, -1)) == 'm') {
 224         $memory_limit = (int)substr($memory_limit, 0, -1) * 1024 * 1024;
 225     } elseif (strtolower(substr($memory_limit, -1)) == 'k') {
 226         $memory_limit = (int)substr($memory_limit, 0, -1) * 1024;
 227     } elseif (strtolower(substr($memory_limit, -1)) == 'g') {
 228         $memory_limit = (int)substr($memory_limit, 0, -1) * 1024 * 1024 * 1024;
 229     } else {
 230         $memory_limit = (int)$memory_limit;
 231     }
 232
 233     // Some of memory is needed for other thins and as treshold.
 234     // Nijel: During export I had allocated (see memory_get_usage function)
 235     //        approx 1.2MB so this comes from that.
 236     if ($memory_limit > 1500000) {
 237         $memory_limit -= 1500000;
 238     }
 239
 240     // Some memory is needed for compression, assume 1/3
 241     $memory_limit /= 8;
 242 }
 243
 244 // Generate filename and mime type if needed
 245 if ($asfile) {
 246     $pma_uri_parts = parse_url($cfg['PmaAbsoluteUri']);
 247     if ($export_type == 'server') {
 248         if (isset($remember_template)) {
 249             $GLOBALS['PMA_Config']->setUserValue('pma_server_filename_template',
 250                 'Export/file_template_server', $filename_template);
 251         }
 252         $filename = str_replace('__SERVER__', $GLOBALS['cfg']['Server']['host'], strftime($filename_template));
 253     } elseif ($export_type == 'database') {
 254         if (isset($remember_template)) {
 255             $GLOBALS['PMA_Config']->setUserValue('pma_db_filename_template',
 256                 'Export/file_template_database', $filename_template);
 257         }
 258         $filename = str_replace('__DB__', $db, str_replace('__SERVER__', $GLOBALS['cfg']['Server']['host'], strftime($filename_template)));
 259     } else {
 260         if (isset($remember_template)) {
 261             $GLOBALS['PMA_Config']->setUserValue('pma_table_filename_template',
 262                 'Export/file_template_table', $filename_template);
 263         }
 264         $filename = str_replace('__TABLE__', $table, str_replace('__DB__', $db, str_replace('__SERVER__', $GLOBALS['cfg']['Server']['host'], strftime($filename_template))));
 265     }
 266
 267     // convert filename to iso-8859-1, it is safer
 268     if (!(isset($cfg['AllowAnywhereRecoding']) && $cfg['AllowAnywhereRecoding'] )) {
 269         $filename = PMA_convert_string($charset, 'iso-8859-1', $filename);
 270     } else {
 271         $filename = PMA_convert_string($convcharset, 'iso-8859-1', $filename);
 272     }
 273
 274     // Grab basic dump extension and mime type
 275     $filename  .= '.' . $export_list[$type]['extension'];
 276     $mime_type  = $export_list[$type]['mime_type'];
 277
 278     // If dump is going to be compressed, set correct mime_type and add
 279     // compression to extension
 280     if ($compression == 'bzip') {
 281         $filename  .= '.bz2';
 282         $mime_type = 'application/x-bzip2';
 283     } elseif ($compression == 'gzip') {
 284         $filename  .= '.gz';
 285         $mime_type = 'application/x-gzip';
 286     } elseif ($compression == 'zip') {
 287         $filename  .= '.zip';
 288         $mime_type = 'application/zip';
 289     }
 290 }
 291
 292 // Open file on server if needed
 293 if ($save_on_server) {
 294     $save_filename = PMA_userDir($cfg['SaveDir']) . preg_replace('@[/\\\\]@', '_', $filename);
 295     unset($message);
 296     if (file_exists($save_filename) && empty($onserverover)) {
 297         $message = PMA_Message::error(__('File %s already exists on server, change filename or check overwrite option.'));
 298         $message->addParam($save_filename);
 299     } else {
 300         if (is_file($save_filename) && !is_writable($save_filename)) {
 301             $message = PMA_Message::error(__('The web server does not have permission to save the file %s.'));
 302             $message->addParam($save_filename);
 303         } else {
 304             if (!$file_handle = @fopen($save_filename, 'w')) {
 305                 $message = PMA_Message::error(__('The web server does not have permission to save the file %s.'));
 306                 $message->addParam($save_filename);
 307             }
 308         }
 309     }
 310     if (isset($message)) {
 311         $GLOBALS['js_include'][] = 'functions.js';
 312         require_once './libraries/header.inc.php';
 313         if ($export_type == 'server') {
 314             $active_page = 'server_export.php';
 315             require './server_export.php';
 316         } elseif ($export_type == 'database') {
 317             $active_page = 'db_export.php';
 318             require './db_export.php';
 319         } else {
 320             $active_page = 'tbl_export.php';
 321             require './tbl_export.php';
 322         }
 323         exit();
 324     }
 325 }
 326
 327 /**
 328  * Send headers depending on whether the user chose to download a dump file
 329  * or not
 330  */
 331 if (!$save_on_server) {
 332     if ($asfile) {
 333         // Download
 334         // (avoid rewriting data containing HTML with anchors and forms;
 335         // this was reported to happen under Plesk)
 336         @ini_set('url_rewriter.tags','');
 337
 338         header('Content-Type: ' . $mime_type);
 339         header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
 340         // Tested behavior of
 341         //       IE 5.50.4807.2300
 342         //       IE 6.0.2800.1106 (small glitch, asks twice when I click Open)
 343         //       IE 6.0.2900.2180
 344         //       Firefox 1.0.6
 345         // in http and https
 346         header('Content-Disposition: attachment; filename="' . $filename . '"');
 347         if (PMA_USR_BROWSER_AGENT == 'IE') {
 348             header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
 349             header('Pragma: public');
 350         } else {
 351             header('Pragma: no-cache');
 352             // test case: exporting a database into a .gz file with Safari
 353             // would produce files not having the current time
 354             // (added this header for Safari but should not harm other browsers)
 355             header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
 356         }
 357     } else {
 358         // HTML
 359         if ($export_type == 'database') {
 360             $num_tables = count($tables);
 361             if ($num_tables == 0) {
 362                 $message = PMA_Message::error(__('No tables found in database.'));
 363                 $GLOBALS['js_include'][] = 'functions.js';
 364                 require_once './libraries/header.inc.php';
 365                 $active_page = 'db_export.php';
 366                 require './db_export.php';
 367                 exit();
 368             }
 369         }
 370         $backup_cfgServer = $cfg['Server'];
 371         require_once './libraries/header.inc.php';
 372         $cfg['Server'] = $backup_cfgServer;
 373         unset($backup_cfgServer);
 374         echo "\n" . '<div align="' . $cell_align_left . '">' . "\n";
 375         //echo '    <pre>' . "\n";
 376         echo '    <form name="nofunction">' . "\n"
 377            // remove auto-select for now: there is no way to select
 378            // only a part of the text; anyway, it should obey
 379            // $cfg['TextareaAutoSelect']
 380            //. '        <textarea name="sqldump" cols="50" rows="30" onclick="this.select();" id="textSQLDUMP" wrap="OFF">' . "\n";
 381            . '        <textarea name="sqldump" cols="50" rows="30" id="textSQLDUMP" wrap="OFF">' . "\n";
 382     } // end download
 383 }
 384
 385 // Fake loop just to allow skip of remain of this code by break, I'd really
 386 // need exceptions here :-)
 387 do {
 388
 389 // Add possibly some comments to export
 390 if (!PMA_exportHeader()) {
 391     break;
 392 }
 393
 394 // Will we need relation & co. setup?
 395 $do_relation = isset($GLOBALS[$what . '_relation']);
 396 $do_comments = isset($GLOBALS[$what . '_comments']);
 397 $do_mime     = isset($GLOBALS[$what . '_mime']);
 398 if ($do_relation || $do_comments || $do_mime) {
 399     require_once './libraries/relation.lib.php';
 400     $cfgRelation = PMA_getRelationsParam();
 401 }
 402 if ($do_mime) {
 403     require_once './libraries/transformations.lib.php';
 404 }
 405
 406 // Include dates in export?
 407 $do_dates   = isset($GLOBALS[$what . '_dates']);
 408
 409 /**
 410  * Builds the dump
 411  */
 412 // Gets the number of tables if a dump of a database has been required
 413 if ($export_type == 'server') {
 414     if (isset($db_select)) {
 415         $tmp_select = implode($db_select, '|');
 416         $tmp_select = '|' . $tmp_select . '|';
 417     }
 418     // Walk over databases
 419     foreach ($GLOBALS['pma']->databases as $current_db) {
 420         if ((isset($tmp_select) && strpos(' ' . $tmp_select, '|' . $current_db . '|'))
 421             || !isset($tmp_select)) {
 422             if (!PMA_exportDBHeader($current_db)) {
 423                 break 2;
 424             }
 425             if (!PMA_exportDBCreate($current_db)) {
 426                 break 2;
 427             }
 428             $tables = PMA_DBI_get_tables($current_db);
 429             $views = array();
 430             foreach ($tables as $table) {
 431                 // if this is a view, collect it for later; views must be exported
 432                 // after the tables
 433                 $is_view = PMA_Table::isView($current_db, $table);
 434                 if ($is_view) {
 435                     $views[] = $table;
 436                 }
 437                 if (isset($GLOBALS[$what . '_structure'])) {
 438                     // for a view, export a stand-in definition of the table
 439                     // to resolve view dependencies
 440                     if (!PMA_exportStructure($current_db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates, $is_view ? 'stand_in' : 'create_table', $export_type)) {
 441                         break 3;
 442                     }
 443                 }
 444                 // if this is a view or a merge table, don't export data
 445                 if (isset($GLOBALS[$what . '_data']) && !($is_view || PMA_Table::isMerge($current_db, $table))) {
 446                     $local_query  = 'SELECT * FROM ' . PMA_backquote($current_db) . '.' . PMA_backquote($table);
 447                     if (!PMA_exportData($current_db, $table, $crlf, $err_url, $local_query)) {
 448                         break 3;
 449                     }
 450                 }
 451                 // now export the triggers (needs to be done after the data because
 452                 // triggers can modify already imported tables)
 453                 if (isset($GLOBALS[$what . '_structure'])) {
 454                     if (!PMA_exportStructure($current_db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates, 'triggers', $export_type)) {
 455                         break 2;
 456                     }
 457                 }
 458             }
 459             foreach($views as $view) {
 460                 // no data export for a view
 461                 if (isset($GLOBALS[$what . '_structure'])) {
 462                     if (!PMA_exportStructure($current_db, $view, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates, 'create_view', $export_type)) {
 463                         break 3;
 464                     }
 465                 }
 466             }
 467             if (!PMA_exportDBFooter($current_db)) {
 468                 break 2;
 469             }
 470         }
 471     }
 472 } elseif ($export_type == 'database') {
 473     if (!PMA_exportDBHeader($db)) {
 474         break;
 475     }
 476     $i = 0;
 477     $views = array();
 478     // $tables contains the choices from the user (via $table_select)
 479     foreach ($tables as $table) {
 480         // if this is a view, collect it for later; views must be exported after
 481         // the tables
 482         $is_view = PMA_Table::isView($db, $table);
 483         if ($is_view) {
 484             $views[] = $table;
 485         }
 486         if (isset($GLOBALS[$what . '_structure'])) {
 487             // for a view, export a stand-in definition of the table
 488             // to resolve view dependencies
 489             if (!PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates, $is_view ? 'stand_in' : 'create_table', $export_type)) {
 490                 break 2;
 491             }
 492         }
 493         // if this is a view or a merge table, don't export data
 494         if (isset($GLOBALS[$what . '_data']) && !($is_view || PMA_Table::isMerge($db, $table))) {
 495             $local_query  = 'SELECT * FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table);
 496             if (!PMA_exportData($db, $table, $crlf, $err_url, $local_query)) {
 497                 break 2;
 498             }
 499         }
 500         // now export the triggers (needs to be done after the data because
 501         // triggers can modify already imported tables)
 502         if (isset($GLOBALS[$what . '_structure'])) {
 503             if (!PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates, 'triggers', $export_type)) {
 504                 break 2;
 505             }
 506         }
 507     }
 508     foreach ($views as $view) {
 509         // no data export for a view
 510         if (isset($GLOBALS[$what . '_structure'])) {
 511             if (!PMA_exportStructure($db, $view, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates, 'create_view', $export_type)) {
 512                 break 2;
 513             }
 514         }
 515     }
 516
 517     if (!PMA_exportDBFooter($db)) {
 518         break;
 519     }
 520 } else {
 521     if (!PMA_exportDBHeader($db)) {
 522         break;
 523     }
 524     // We export just one table
 525     // $allrows comes from the form when "Dump all rows" has been selected
 526     if ($allrows == '0' && $limit_to > 0 && $limit_from >= 0) {
 527         $add_query  = ' LIMIT '
 528                     . (($limit_from > 0) ? $limit_from . ', ' : '')
 529                     . $limit_to;
 530     } else {
 531         $add_query  = '';
 532     }
 533
 534     $is_view = PMA_Table::isView($db, $table);
 535     if (isset($GLOBALS[$what . '_structure'])) {
 536         if (!PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates, $is_view ? 'create_view' : 'create_table', $export_type)) {
 537             break;
 538         }
 539     }
 540     // If this is an export of a single view, we have to export data;
 541     // for example, a PDF report
 542     // if it is a merge table, no data is exported
 543     if (isset($GLOBALS[$what . '_data']) && ! PMA_Table::isMerge($db, $table)) {
 544         if (!empty($sql_query)) {
 545             // only preg_replace if needed
 546             if (!empty($add_query)) {
 547                 // remove trailing semicolon before adding a LIMIT
 548                 $sql_query = preg_replace('%;\s*$%', '', $sql_query);
 549             }
 550             $local_query = $sql_query . $add_query;
 551             PMA_DBI_select_db($db);
 552         } else {
 553             $local_query  = 'SELECT * FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table) . $add_query;
 554         }
 555         if (!PMA_exportData($db, $table, $crlf, $err_url, $local_query)) {
 556             break;
 557         }
 558     }
 559     // now export the triggers (needs to be done after the data because
 560     // triggers can modify already imported tables)
 561     if (isset($GLOBALS[$what . '_structure'])) {
 562         if (!PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates, 'triggers', $export_type)) {
 563             break 2;
 564         }
 565     }
 566     if (!PMA_exportDBFooter($db)) {
 567         break;
 568     }
 569 }
 570 if (!PMA_exportFooter()) {
 571     break;
 572 }
 573
 574 } while (false);
 575 // End of fake loop
 576
 577 if ($save_on_server && isset($message)) {
 578     $GLOBALS['js_include'][] = 'functions.js';
 579     require_once './libraries/header.inc.php';
 580     if ($export_type == 'server') {
 581         $active_page = 'server_export.php';
 582         require './server_export.php';
 583     } elseif ($export_type == 'database') {
 584         $active_page = 'db_export.php';
 585         require './db_export.php';
 586     } else {
 587         $active_page = 'tbl_export.php';
 588         require './tbl_export.php';
 589     }
 590     exit();
 591 }
 592
 593 /**
 594  * Send the dump as a file...
 595  */
 596 if (!empty($asfile)) {
 597     // Convert the charset if required.
 598     if ($output_charset_conversion) {
 599         $dump_buffer = PMA_convert_string($GLOBALS['charset'], $GLOBALS['charset_of_file'], $dump_buffer);
 600     }
 601
 602     // Do the compression
 603     // 1. as a zipped file
 604     if ($compression == 'zip') {
 605         if (@function_exists('gzcompress')) {
 606             $zipfile = new zipfile();
 607             $zipfile -> addFile($dump_buffer, substr($filename, 0, -4));
 608             $dump_buffer = $zipfile -> file();
 609         }
 610     }
 611     // 2. as a bzipped file
 612     elseif ($compression == 'bzip') {
 613         if (@function_exists('bzcompress')) {
 614             $dump_buffer = bzcompress($dump_buffer);
 615         }
 616     }
 617     // 3. as a gzipped file
 618     elseif ($compression == 'gzip') {
 619         if (@function_exists('gzencode') && !@ini_get('zlib.output_compression')) {
 620             // without the optional parameter level because it bug
 621             $dump_buffer = gzencode($dump_buffer);
 622         }
 623     }
 624
 625     /* If ve saved on server, we have to close file now */
 626     if ($save_on_server) {
 627         $write_result = @fwrite($file_handle, $dump_buffer);
 628         fclose($file_handle);
 629         if (strlen($dump_buffer) !=0 && (!$write_result || ($write_result != strlen($dump_buffer)))) {
 630             $message = new PMA_Message(__('Insufficient space to save the file %s.'), PMA_Message::ERROR, $save_filename);
 631         } else {
 632             $message = new PMA_Message(__('Dump has been saved to file %s.'), PMA_Message::SUCCESS, $save_filename);
 633         }
 634
 635         $GLOBALS['js_include'][] = 'functions.js';
 636         require_once './libraries/header.inc.php';
 637         if ($export_type == 'server') {
 638             $active_page = 'server_export.php';
 639             require_once './server_export.php';
 640         } elseif ($export_type == 'database') {
 641             $active_page = 'db_export.php';
 642             require_once './db_export.php';
 643         } else {
 644             $active_page = 'tbl_export.php';
 645             require_once './tbl_export.php';
 646         }
 647         exit();
 648     } else {
 649         echo $dump_buffer;
 650     }
 651 }
 652 /**
 653  * Displays the dump...
 654  */
 655 else {
 656     /**
 657      * Close the html tags and add the footers in dump is displayed on screen
 658      */
 659     //echo '    </pre>' . "\n";
 660     echo '</textarea>' . "\n"
 661        . '    </form>' . "\n";
 662     echo '</div>' . "\n";
 663     echo "\n";
 664 ?>
 665 <script type="text/javascript">
 666 //<![CDATA[
 667     var bodyWidth=null; var bodyHeight=null;
 668     if (document.getElementById('textSQLDUMP')) {
 669         bodyWidth  = self.innerWidth;
 670         bodyHeight = self.innerHeight;
 671         if (!bodyWidth && !bodyHeight) {
 672             if (document.compatMode && document.compatMode == "BackCompat") {
 673                 bodyWidth  = document.body.clientWidth;
 674                 bodyHeight = document.body.clientHeight;
 675             } else if (document.compatMode && document.compatMode == "CSS1Compat") {
 676                 bodyWidth  = document.documentElement.clientWidth;
 677                 bodyHeight = document.documentElement.clientHeight;
 678             }
 679         }
 680         document.getElementById('textSQLDUMP').style.width=(bodyWidth-50) + 'px';
 681         document.getElementById('textSQLDUMP').style.height=(bodyHeight-100) + 'px';
 682     }
 683 //]]>
 684 </script>
 685 <?php
 686     require_once './libraries/footer.inc.php';
 687 } // end if
 688 ?>