export.php

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