export.php

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