phpmyadmin/export.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Main export handling code
   5  *
   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 /**
  17  * Sets globals from $_POST
  18  *
  19  * - Please keep the parameters in order of their appearance in the form
  20  * - Some of these parameters are not used, as the code below directly
  21  *   verifies from the superglobal $_POST or $_REQUEST
  22  */
  23 $post_params = array(
  24         'db',
  25         'table',
  26         'single_table',
  27         'export_type',
  28         'export_method',
  29         'quick_or_custom',
  30         'db_select',
  31         'table_select',
  32         'limit_to',
  33         'limit_from',
  34         'allrows',
  35         'output_format',
  36         'filename_template',
  37         'remember_template',
  38         'charset_of_file',
  39         'compression',
  40         'what',
  41         'htmlword_structure_or_data',
  42         'htmlword_null',
  43         'htmlword_columns',
  44         'mediawiki_structure_or_data',
  45         'mediawiki_caption',
  46         'pdf_report_title',
  47         'pdf_structure_or_data',
  48         'odt_structure_or_data',
  49         'odt_relation',
  50         'odt_comments',
  51         'odt_mime',
  52         'odt_columns',
  53         'odt_null',
  54         'codegen_structure_or_data',
  55         'codegen_format',
  56         'excel_null',
  57         'excel_removeCRLF',
  58         'excel_columns',
  59         'excel_edition',
  60         'excel_structure_or_data',
  61         'yaml_structure_or_data',
  62         'ods_null',
  63         'ods_structure_or_data',
  64         'ods_columns',
  65         'json_structure_or_data',
  66         'xml_structure_or_data',
  67         'xml_export_functions',
  68         'xml_export_procedures',
  69         'xml_export_tables',
  70         'xml_export_triggers',
  71         'xml_export_views',
  72         'xml_export_contents',
  73         'texytext_structure_or_data',
  74         'texytext_columns',
  75         'texytext_null',
  76         'phparray_structure_or_data',
  77         'sql_include_comments',
  78         'sql_header_comment',
  79         'sql_dates',
  80         'sql_relation',
  81         'sql_mime',
  82         'sql_use_transaction',
  83         'sql_disable_fk',
  84         'sql_compatibility',
  85         'sql_structure_or_data',
  86         'sql_drop_table',
  87         'sql_procedure_function',
  88         'sql_create_table_statements',
  89         'sql_if_not_exists',
  90         'sql_auto_increment',
  91         'sql_backquotes',
  92         'sql_truncate',
  93         'sql_delayed',
  94         'sql_ignore',
  95         'sql_type',
  96         'sql_insert_syntax',
  97         'sql_max_query_size',
  98         'sql_hex_for_blob',
  99         'sql_utc_time',
 100         'csv_separator',
 101         'csv_enclosed',
 102         'csv_escaped',
 103         'csv_terminated',
 104         'csv_null',
 105         'csv_removeCRLF',
 106         'csv_columns',
 107         'csv_structure_or_data',
 108         // csv_replace should have been here but we use it directly from $_POST
 109         'latex_caption',
 110         'latex_structure_or_data',
 111         'latex_structure_caption',
 112         'latex_structure_continued_caption',
 113         'latex_structure_label',
 114         'latex_relation',
 115         'latex_comments',
 116         'latex_mime',
 117         'latex_columns',
 118         'latex_data_caption',
 119         'latex_data_continued_caption',
 120         'latex_data_label',
 121         'latex_null'
 122 );
 123
 124 foreach ($post_params as $one_post_param) {
 125     if (isset($_POST[$one_post_param])) {
 126         $GLOBALS[$one_post_param] = $_POST[$one_post_param];
 127     }
 128 }
 129
 130 // sanitize this parameter which will be used below in a file inclusion
 131 $what = PMA_securePath($what);
 132
 133 PMA_Util::checkParameters(array('what', 'export_type'));
 134
 135 // export class instance, not array of properties, as before
 136 $export_plugin = PMA_getPlugin(
 137     "export",
 138     $what,
 139     'libraries/plugins/export/',
 140     array(
 141         'export_type' => $export_type,
 142         'single_table' => isset($single_table)
 143     )
 144 );
 145
 146 // Backward compatbility
 147 $type = $what;
 148
 149 // Check export type
 150 if (! isset($export_plugin)) {
 151     PMA_fatalError(__('Bad type!'));
 152 }
 153
 154 /**
 155  * valid compression methods
 156  */
 157 $compression_methods = array(
 158     'zip',
 159     'gzip',
 160     'bzip2',
 161 );
 162
 163 /**
 164  * init and variable checking
 165  */
 166 $compression = false;
 167 $onserver = false;
 168 $save_on_server = false;
 169 $buffer_needed = false;
 170
 171 // Is it a quick or custom export?
 172 if ($_REQUEST['quick_or_custom'] == 'quick') {
 173     $quick_export = true;
 174 } else {
 175     $quick_export = false;
 176 }
 177
 178 if ($_REQUEST['output_format'] == 'astext') {
 179     $asfile = false;
 180 } else {
 181     $asfile = true;
 182     if (in_array($_REQUEST['compression'], $compression_methods)) {
 183         $compression = $_REQUEST['compression'];
 184         $buffer_needed = true;
 185     }
 186     if (($quick_export && ! empty($_REQUEST['quick_export_onserver']))
 187         || (! $quick_export && ! empty($_REQUEST['onserver']))
 188     ) {
 189         if ($quick_export) {
 190             $onserver = $_REQUEST['quick_export_onserver'];
 191         } else {
 192             $onserver = $_REQUEST['onserver'];
 193         }
 194         // Will we save dump on server?
 195         $save_on_server = ! empty($cfg['SaveDir']) && $onserver;
 196     }
 197 }
 198
 199 // Does export require to be into file?
 200 if ($export_plugin->getProperties()->getForceFile() != null && ! $asfile) {
 201     $message = PMA_Message::error(
 202         __('Selected export type has to be saved in file!')
 203     );
 204     if ($export_type == 'server') {
 205         $active_page = 'server_export.php';
 206         include 'server_export.php';
 207     } elseif ($export_type == 'database') {
 208         $active_page = 'db_export.php';
 209         include 'db_export.php';
 210     } else {
 211         $active_page = 'tbl_export.php';
 212         include 'tbl_export.php';
 213     }
 214     exit();
 215 }
 216
 217 // Generate error url and check for needed variables
 218 if ($export_type == 'server') {
 219     $err_url = 'server_export.php?' . PMA_generate_common_url();
 220 } elseif ($export_type == 'database' && strlen($db)) {
 221     $err_url = 'db_export.php?' . PMA_generate_common_url($db);
 222     // Check if we have something to export
 223     if (isset($table_select)) {
 224         $tables = $table_select;
 225     } else {
 226         $tables = array();
 227     }
 228 } elseif ($export_type == 'table' && strlen($db) && strlen($table)) {
 229     $err_url = 'tbl_export.php?' . PMA_generate_common_url($db, $table);
 230 } else {
 231     PMA_fatalError(__('Bad parameters!'));
 232 }
 233
 234 /**
 235  * Increase time limit for script execution and initializes some variables
 236  */
 237 @set_time_limit($cfg['ExecTimeLimit']);
 238 if (! empty($cfg['MemoryLimit'])) {
 239     @ini_set('memory_limit', $cfg['MemoryLimit']);
 240 }
 241
 242 // Start with empty buffer
 243 $dump_buffer = '';
 244 $dump_buffer_len = 0;
 245
 246 // We send fake headers to avoid browser timeout when buffering
 247 $time_start = time();
 248
 249
 250 /**
 251  * Detect ob_gzhandler
 252  *
 253  * @return bool
 254  */
 255 function PMA_isGzHandlerEnabled()
 256 {
 257     return in_array('ob_gzhandler', ob_list_handlers());
 258 }
 259
 260 /**
 261  * Detect whether gzencode is needed; it might not be needed if
 262  * the server is already compressing by itself
 263  *
 264  * @return bool Whether gzencode is needed
 265  */
 266 function PMA_gzencodeNeeded()
 267 {
 268     if (@function_exists('gzencode')
 269         && ! @ini_get('zlib.output_compression')
 270         // Here, we detect Apache's mod_deflate so we bet that
 271         // this module is active for this instance of phpMyAdmin
 272         // and therefore, will gzip encode the content
 273         && ! (function_exists('apache_get_modules')
 274             && in_array('mod_deflate', apache_get_modules()))
 275         && ! PMA_isGzHandlerEnabled()
 276     ) {
 277         return true;
 278     } else {
 279         return false;
 280     }
 281 }
 282
 283 /**
 284  * Output handler for all exports, if needed buffering, it stores data into
 285  * $dump_buffer, otherwise it prints thems out.
 286  *
 287  * @param string $line the insert statement
 288  *
 289  * @return bool Whether output succeeded
 290  */
 291 function PMA_exportOutputHandler($line)
 292 {
 293     global $time_start, $dump_buffer, $dump_buffer_len, $save_filename;
 294
 295     // Kanji encoding convert feature
 296     if ($GLOBALS['output_kanji_conversion']) {
 297         $line = PMA_kanji_str_conv(
 298             $line,
 299             $GLOBALS['knjenc'],
 300             isset($GLOBALS['xkana']) ? $GLOBALS['xkana'] : ''
 301         );
 302     }
 303     // If we have to buffer data, we will perform everything at once at the end
 304     if ($GLOBALS['buffer_needed']) {
 305
 306         $dump_buffer .= $line;
 307         if ($GLOBALS['onfly_compression']) {
 308
 309             $dump_buffer_len += strlen($line);
 310
 311             if ($dump_buffer_len > $GLOBALS['memory_limit']) {
 312                 if ($GLOBALS['output_charset_conversion']) {
 313                     $dump_buffer = PMA_convert_string(
 314                         'utf-8',
 315                         $GLOBALS['charset_of_file'],
 316                         $dump_buffer
 317                     );
 318                 }
 319                 // as bzipped
 320                 if ($GLOBALS['compression'] == 'bzip2'
 321                     && @function_exists('bzcompress')
 322                 ) {
 323                     $dump_buffer = bzcompress($dump_buffer);
 324                 } elseif ($GLOBALS['compression'] == 'gzip'
 325                      && PMA_gzencodeNeeded()
 326                 ) {
 327                     // as a gzipped file
 328                     // without the optional parameter level because it bugs
 329                     $dump_buffer = gzencode($dump_buffer);
 330                 }
 331                 if ($GLOBALS['save_on_server']) {
 332                     $write_result = @fwrite($GLOBALS['file_handle'], $dump_buffer);
 333                     if (! $write_result || ($write_result != strlen($dump_buffer))) {
 334                         $GLOBALS['message'] = PMA_Message::error(
 335                             __('Insufficient space to save the file %s.')
 336                         );
 337                         $GLOBALS['message']->addParam($save_filename);
 338                         return false;
 339                     }
 340                 } else {
 341                     echo $dump_buffer;
 342                 }
 343                 $dump_buffer = '';
 344                 $dump_buffer_len = 0;
 345             }
 346         } else {
 347             $time_now = time();
 348             if ($time_start >= $time_now + 30) {
 349                 $time_start = $time_now;
 350                 header('X-pmaPing: Pong');
 351             } // end if
 352         }
 353     } else {
 354         if ($GLOBALS['asfile']) {
 355             if ($GLOBALS['output_charset_conversion']) {
 356                 $line = PMA_convert_string(
 357                     'utf-8',
 358                     $GLOBALS['charset_of_file'],
 359                     $line
 360                 );
 361             }
 362             if ($GLOBALS['save_on_server'] && strlen($line) > 0) {
 363                 $write_result = @fwrite($GLOBALS['file_handle'], $line);
 364                 if (! $write_result || ($write_result != strlen($line))) {
 365                     $GLOBALS['message'] = PMA_Message::error(
 366                         __('Insufficient space to save the file %s.')
 367                     );
 368                     $GLOBALS['message']->addParam($save_filename);
 369                     return false;
 370                 }
 371                 $time_now = time();
 372                 if ($time_start >= $time_now + 30) {
 373                     $time_start = $time_now;
 374                     header('X-pmaPing: Pong');
 375                 } // end if
 376             } else {
 377                 // We export as file - output normally
 378                 echo $line;
 379             }
 380         } else {
 381             // We export as html - replace special chars
 382             echo htmlspecialchars($line);
 383         }
 384     }
 385     return true;
 386 } // end of the 'PMA_exportOutputHandler()' function
 387
 388 // Defines the default <CR><LF> format.
 389 // For SQL always use \n as MySQL wants this on all platforms.
 390 if ($what == 'sql') {
 391     $crlf = "\n";
 392 } else {
 393     $crlf = PMA_Util::whichCrlf();
 394 }
 395
 396 $output_kanji_conversion = function_exists('PMA_kanji_str_conv') && $type != 'xls';
 397
 398 // Do we need to convert charset?
 399 $output_charset_conversion = $asfile
 400     && $GLOBALS['PMA_recoding_engine'] != PMA_CHARSET_NONE
 401     && isset($charset_of_file) && $charset_of_file != 'utf-8'
 402     && $type != 'xls';
 403
 404 // Use on the fly compression?
 405 $onfly_compression = $GLOBALS['cfg']['CompressOnFly']
 406     && ($compression == 'gzip' || $compression == 'bzip2');
 407 if ($onfly_compression) {
 408     $memory_limit = trim(@ini_get('memory_limit'));
 409     // 2 MB as default
 410     if (empty($memory_limit)) {
 411         $memory_limit = 2 * 1024 * 1024;
 412     }
 413
 414     if (strtolower(substr($memory_limit, -1)) == 'm') {
 415         $memory_limit = (int)substr($memory_limit, 0, -1) * 1024 * 1024;
 416     } elseif (strtolower(substr($memory_limit, -1)) == 'k') {
 417         $memory_limit = (int)substr($memory_limit, 0, -1) * 1024;
 418     } elseif (strtolower(substr($memory_limit, -1)) == 'g') {
 419         $memory_limit = (int)substr($memory_limit, 0, -1) * 1024 * 1024 * 1024;
 420     } else {
 421         $memory_limit = (int)$memory_limit;
 422     }
 423
 424     // Some of memory is needed for other thins and as treshold.
 425     // Nijel: During export I had allocated (see memory_get_usage function)
 426     //        approx 1.2MB so this comes from that.
 427     if ($memory_limit > 1500000) {
 428         $memory_limit -= 1500000;
 429     }
 430
 431     // Some memory is needed for compression, assume 1/3
 432     $memory_limit /= 8;
 433 }
 434
 435 // Generate filename and mime type if needed
 436 if ($asfile) {
 437     $pma_uri_parts = parse_url($cfg['PmaAbsoluteUri']);
 438     if ($export_type == 'server') {
 439         if (isset($remember_template)) {
 440             $GLOBALS['PMA_Config']->setUserValue(
 441                 'pma_server_filename_template',
 442                 'Export/file_template_server',
 443                 $filename_template
 444             );
 445         }
 446     } elseif ($export_type == 'database') {
 447         if (isset($remember_template)) {
 448             $GLOBALS['PMA_Config']->setUserValue(
 449                 'pma_db_filename_template',
 450                 'Export/file_template_database',
 451                 $filename_template
 452             );
 453         }
 454     } else {
 455         if (isset($remember_template)) {
 456             $GLOBALS['PMA_Config']->setUserValue(
 457                 'pma_table_filename_template',
 458                 'Export/file_template_table',
 459                 $filename_template
 460             );
 461         }
 462     }
 463     $filename = PMA_Util::expandUserString($filename_template);
 464     // remove dots in filename (coming from either the template or already
 465     // part of the filename) to avoid a remote code execution vulnerability
 466     $filename = PMA_sanitizeFilename($filename, $replaceDots = true);
 467
 468     // Grab basic dump extension and mime type
 469     // Check if the user already added extension;
 470     // get the substring where the extension would be if it was included
 471     $extension_start_pos = strlen($filename) - strlen(
 472         $export_plugin->getProperties()->getExtension()
 473     ) - 1;
 474     $user_extension = substr($filename, $extension_start_pos, strlen($filename));
 475     $required_extension = "." . $export_plugin->getProperties()->getExtension();
 476     if (strtolower($user_extension) != $required_extension) {
 477         $filename  .= $required_extension;
 478     }
 479     $mime_type  = $export_plugin->getProperties()->getMimeType();
 480
 481     // If dump is going to be compressed, set correct mime_type and add
 482     // compression to extension
 483     if ($compression == 'bzip2') {
 484         $filename  .= '.bz2';
 485         $mime_type = 'application/x-bzip2';
 486     } elseif ($compression == 'gzip') {
 487         $filename  .= '.gz';
 488         $mime_type = 'application/x-gzip';
 489     } elseif ($compression == 'zip') {
 490         $filename  .= '.zip';
 491         $mime_type = 'application/zip';
 492     }
 493 }
 494
 495 // Open file on server if needed
 496 if ($save_on_server) {
 497     $save_filename = PMA_Util::userDir($cfg['SaveDir'])
 498         . preg_replace('@[/\\\\]@', '_', $filename);
 499     unset($message);
 500     if (file_exists($save_filename)
 501         && ((! $quick_export && empty($onserverover))
 502         || ($quick_export
 503         && $_REQUEST['quick_export_onserverover'] != 'saveitover'))
 504     ) {
 505         $message = PMA_Message::error(
 506             __('File %s already exists on server, change filename or check overwrite option.')
 507         );
 508         $message->addParam($save_filename);
 509     } else {
 510         if (is_file($save_filename) && ! is_writable($save_filename)) {
 511             $message = PMA_Message::error(
 512                 __('The web server does not have permission to save the file %s.')
 513             );
 514             $message->addParam($save_filename);
 515         } else {
 516             if (! $file_handle = @fopen($save_filename, 'w')) {
 517                 $message = PMA_Message::error(
 518                     __('The web server does not have permission to save the file %s.')
 519                 );
 520                 $message->addParam($save_filename);
 521             }
 522         }
 523     }
 524     if (isset($message)) {
 525         if ($export_type == 'server') {
 526             $active_page = 'server_export.php';
 527             include 'server_export.php';
 528         } elseif ($export_type == 'database') {
 529             $active_page = 'db_export.php';
 530             include 'db_export.php';
 531         } else {
 532             $active_page = 'tbl_export.php';
 533             include 'tbl_export.php';
 534         }
 535         exit();
 536     }
 537 }
 538
 539 /**
 540  * Send headers depending on whether the user chose to download a dump file
 541  * or not
 542  */
 543 if (! $save_on_server) {
 544     if ($asfile) {
 545         // Download
 546         // (avoid rewriting data containing HTML with anchors and forms;
 547         // this was reported to happen under Plesk)
 548         @ini_set('url_rewriter.tags', '');
 549         $filename = PMA_sanitizeFilename($filename);
 550
 551         PMA_downloadHeader($filename, $mime_type);
 552     } else {
 553         // HTML
 554         if ($export_type == 'database') {
 555             $num_tables = count($tables);
 556             if ($num_tables == 0) {
 557                 $message = PMA_Message::error(__('No tables found in database.'));
 558                 $active_page = 'db_export.php';
 559                 include 'db_export.php';
 560                 exit();
 561             }
 562         }
 563         $backup_cfgServer = $cfg['Server'];
 564         $cfg['Server'] = $backup_cfgServer;
 565         unset($backup_cfgServer);
 566         echo "\n" . '<div style="text-align: ' . $cell_align_left . '">' . "\n";
 567         //echo '    <pre>' . "\n";
 568
 569         /**
 570          * Displays a back button with all the $_REQUEST data in the URL
 571          * (store in a variable to also display after the textarea)
 572          */
 573         $back_button = '<p>[ <a href="';
 574         if ($export_type == 'server') {
 575             $back_button .= 'server_export.php?' . PMA_generate_common_url();
 576         } elseif ($export_type == 'database') {
 577             $back_button .= 'db_export.php?' . PMA_generate_common_url($db);
 578         } else {
 579             $back_button .= 'tbl_export.php?' . PMA_generate_common_url($db, $table);
 580         }
 581
 582         // Convert the multiple select elements from an array to a string
 583         if ($export_type == 'server' && isset($_REQUEST['db_select'])) {
 584             $_REQUEST['db_select'] = implode(",", $_REQUEST['db_select']);
 585         } elseif ($export_type == 'database' && isset($_REQUEST['table_select'])) {
 586             $_REQUEST['table_select'] = implode(",", $_REQUEST['table_select']);
 587         }
 588
 589         foreach ($_REQUEST as $name => $value) {
 590             $back_button .= '&amp;' . urlencode($name) . '=' . urlencode($value);
 591         }
 592         $back_button .= '&amp;repopulate=1">Back</a> ]</p>';
 593
 594         echo $back_button;
 595         echo '    <form name="nofunction">' . "\n"
 596            // remove auto-select for now: there is no way to select
 597            // only a part of the text; anyway, it should obey
 598            // $cfg['TextareaAutoSelect']
 599            //. '        <textarea name="sqldump" cols="50" rows="30" onclick="this.select();" id="textSQLDUMP" wrap="OFF">' . "\n";
 600            . '        <textarea name="sqldump" cols="50" rows="30" id="textSQLDUMP" wrap="OFF">' . "\n";
 601     } // end download
 602 }
 603
 604 // Fake loop just to allow skip of remain of this code by break, I'd really
 605 // need exceptions here :-)
 606 do {
 607
 608     // Add possibly some comments to export
 609     if (! $export_plugin->exportHeader($db)) {
 610         break;
 611     }
 612
 613     // Will we need relation & co. setup?
 614     $do_relation = isset($GLOBALS[$what . '_relation']);
 615     $do_comments = isset($GLOBALS[$what . '_include_comments']);
 616     $do_mime     = isset($GLOBALS[$what . '_mime']);
 617     if ($do_relation || $do_comments || $do_mime) {
 618         $cfgRelation = PMA_getRelationsParam();
 619     }
 620     if ($do_mime) {
 621         include_once 'libraries/transformations.lib.php';
 622     }
 623
 624     // Include dates in export?
 625     $do_dates = isset($GLOBALS[$what . '_dates']);
 626
 627     /**
 628      * Builds the dump
 629      */
 630     // Gets the number of tables if a dump of a database has been required
 631     if ($export_type == 'server') {
 632         if (isset($db_select)) {
 633             $tmp_select = implode($db_select, '|');
 634             $tmp_select = '|' . $tmp_select . '|';
 635         }
 636         // Walk over databases
 637         foreach ($GLOBALS['pma']->databases as $current_db) {
 638             if (isset($tmp_select)
 639                 && strpos(' ' . $tmp_select, '|' . $current_db . '|')
 640             ) {
 641                 if (! $export_plugin->exportDBHeader($current_db)) {
 642                     break 2;
 643                 }
 644                 if (! $export_plugin->exportDBCreate($current_db)) {
 645                     break 2;
 646                 }
 647                 if (method_exists($export_plugin, 'exportRoutines')
 648                     && strpos($GLOBALS['sql_structure_or_data'], 'structure') !== false
 649                     && isset($GLOBALS['sql_procedure_function'])
 650                 ) {
 651                     $export_plugin->exportRoutines($current_db);
 652                 }
 653
 654                 $tables = PMA_DBI_get_tables($current_db);
 655                 $views = array();
 656                 foreach ($tables as $table) {
 657                     // if this is a view, collect it for later;
 658                     // views must be exported after the tables
 659                     $is_view = PMA_Table::isView($current_db, $table);
 660                     if ($is_view) {
 661                         $views[] = $table;
 662                     }
 663                     if ($GLOBALS[$what . '_structure_or_data'] == 'structure'
 664                         || $GLOBALS[$what . '_structure_or_data'] == 'structure_and_data'
 665                     ) {
 666                         // for a view, export a stand-in definition of the table
 667                         // to resolve view dependencies
 668                         if (! $export_plugin->exportStructure(
 669                             $current_db, $table, $crlf, $err_url,
 670                             $is_view ? 'stand_in' : 'create_table', $export_type,
 671                             $do_relation, $do_comments, $do_mime, $do_dates
 672                         )) {
 673                             break 3;
 674                         }
 675                     }
 676                     // if this is a view or a merge table, don't export data
 677                     if (($GLOBALS[$what . '_structure_or_data'] == 'data'
 678                         || $GLOBALS[$what . '_structure_or_data'] == 'structure_and_data')
 679                         && ! ($is_view || PMA_Table::isMerge($current_db, $table))
 680                     ) {
 681                         $local_query  = 'SELECT * FROM ' . PMA_Util::backquote($current_db)
 682                             . '.' . PMA_Util::backquote($table);
 683                         if (! $export_plugin->exportData($current_db, $table, $crlf, $err_url, $local_query)) {
 684                             break 3;
 685                         }
 686                     }
 687                     // now export the triggers (needs to be done after the data
 688                     // because triggers can modify already imported tables)
 689                     if ($GLOBALS[$what . '_structure_or_data'] == 'structure'
 690                         || $GLOBALS[$what . '_structure_or_data'] == 'structure_and_data'
 691                     ) {
 692                         if (! $export_plugin->exportStructure(
 693                             $current_db, $table, $crlf, $err_url,
 694                             'triggers', $export_type,
 695                             $do_relation, $do_comments, $do_mime, $do_dates
 696                         )) {
 697                             break 2;
 698                         }
 699                     }
 700                 }
 701                 foreach ($views as $view) {
 702                     // no data export for a view
 703                     if ($GLOBALS[$what . '_structure_or_data'] == 'structure'
 704                         || $GLOBALS[$what . '_structure_or_data'] == 'structure_and_data'
 705                     ) {
 706                         if (! $export_plugin->exportStructure(
 707                             $current_db, $view, $crlf, $err_url,
 708                             'create_view', $export_type,
 709                             $do_relation, $do_comments, $do_mime, $do_dates
 710                         )) {
 711                             break 3;
 712                         }
 713                     }
 714                 }
 715                 if (! $export_plugin->exportDBFooter($current_db)) {
 716                     break 2;
 717                 }
 718             }
 719         }
 720     } elseif ($export_type == 'database') {
 721         if (! $export_plugin->exportDBHeader($db)) {
 722             break;
 723         }
 724         if (! $export_plugin->exportDBCreate($db)) {
 725             break;
 726         }
 727
 728         if (method_exists($export_plugin, 'exportRoutines')
 729             && strpos($GLOBALS['sql_structure_or_data'], 'structure') !== false
 730             && isset($GLOBALS['sql_procedure_function'])
 731         ) {
 732             $export_plugin->exportRoutines($db);
 733         }
 734
 735         $i = 0;
 736         $views = array();
 737         // $tables contains the choices from the user (via $table_select)
 738         foreach ($tables as $table) {
 739             // if this is a view, collect it for later; views must be exported after
 740             // the tables
 741             $is_view = PMA_Table::isView($db, $table);
 742             if ($is_view) {
 743                 $views[] = $table;
 744             }
 745             if ($GLOBALS[$what . '_structure_or_data'] == 'structure'
 746                 || $GLOBALS[$what . '_structure_or_data'] == 'structure_and_data'
 747             ) {
 748                 // for a view, export a stand-in definition of the table
 749                 // to resolve view dependencies
 750                 if (! $export_plugin->exportStructure(
 751                     $db, $table, $crlf, $err_url,
 752                     $is_view ? 'stand_in' : 'create_table', $export_type,
 753                     $do_relation, $do_comments, $do_mime, $do_dates
 754                 )) {
 755                     break 2;
 756                 }
 757             }
 758             // if this is a view or a merge table, don't export data
 759             if (($GLOBALS[$what . '_structure_or_data'] == 'data'
 760                 || $GLOBALS[$what . '_structure_or_data'] == 'structure_and_data')
 761                 && ! ($is_view || PMA_Table::isMerge($db, $table))
 762             ) {
 763                 $local_query  = 'SELECT * FROM ' . PMA_Util::backquote($db)
 764                     . '.' . PMA_Util::backquote($table);
 765                 if (! $export_plugin->exportData($db, $table, $crlf, $err_url, $local_query)) {
 766                     break 2;
 767                 }
 768             }
 769             // now export the triggers (needs to be done after the data because
 770             // triggers can modify already imported tables)
 771             if ($GLOBALS[$what . '_structure_or_data'] == 'structure'
 772                 || $GLOBALS[$what . '_structure_or_data'] == 'structure_and_data'
 773             ) {
 774                 if (! $export_plugin->exportStructure(
 775                     $db, $table, $crlf, $err_url,
 776                     'triggers', $export_type,
 777                     $do_relation, $do_comments, $do_mime, $do_dates
 778                 )) {
 779                     break 2;
 780                 }
 781             }
 782         }
 783         foreach ($views as $view) {
 784             // no data export for a view
 785             if ($GLOBALS[$what . '_structure_or_data'] == 'structure'
 786                 || $GLOBALS[$what . '_structure_or_data'] == 'structure_and_data'
 787             ) {
 788                 if (! $export_plugin->exportStructure(
 789                     $db, $view, $crlf, $err_url,
 790                     'create_view', $export_type,
 791                     $do_relation, $do_comments, $do_mime, $do_dates
 792                 )) {
 793                     break 2;
 794                 }
 795             }
 796         }
 797
 798         if (! $export_plugin->exportDBFooter($db)) {
 799             break;
 800         }
 801     } else {
 802         if (! $export_plugin->exportDBHeader($db)) {
 803             break;
 804         }
 805         // We export just one table
 806         // $allrows comes from the form when "Dump all rows" has been selected
 807         if (isset($allrows) && $allrows == '0' && $limit_to > 0 && $limit_from >= 0) {
 808             $add_query  = ' LIMIT '
 809                         . (($limit_from > 0) ? $limit_from . ', ' : '')
 810                         . $limit_to;
 811         } else {
 812             $add_query  = '';
 813         }
 814
 815         $is_view = PMA_Table::isView($db, $table);
 816         if ($GLOBALS[$what . '_structure_or_data'] == 'structure'
 817             || $GLOBALS[$what . '_structure_or_data'] == 'structure_and_data'
 818         ) {
 819             if (! $export_plugin->exportStructure(
 820                 $db, $table, $crlf, $err_url,
 821                 $is_view ? 'create_view' : 'create_table', $export_type,
 822                 $do_relation, $do_comments, $do_mime, $do_dates
 823             )) {
 824                 break;
 825             }
 826         }
 827         // If this is an export of a single view, we have to export data;
 828         // for example, a PDF report
 829         // if it is a merge table, no data is exported
 830         if (($GLOBALS[$what . '_structure_or_data'] == 'data'
 831             || $GLOBALS[$what . '_structure_or_data'] == 'structure_and_data')
 832             && ! PMA_Table::isMerge($db, $table)
 833         ) {
 834             if (! empty($sql_query)) {
 835                 // only preg_replace if needed
 836                 if (! empty($add_query)) {
 837                     // remove trailing semicolon before adding a LIMIT
 838                     $sql_query = preg_replace('%;\s*$%', '', $sql_query);
 839                 }
 840                 $local_query = $sql_query . $add_query;
 841                 PMA_DBI_select_db($db);
 842             } else {
 843                 $local_query  = 'SELECT * FROM ' . PMA_Util::backquote($db)
 844                     . '.' . PMA_Util::backquote($table) . $add_query;
 845             }
 846             if (! $export_plugin->exportData($db, $table, $crlf, $err_url, $local_query)) {
 847                 break;
 848             }
 849         }
 850         // now export the triggers (needs to be done after the data because
 851         // triggers can modify already imported tables)
 852         if ($GLOBALS[$what . '_structure_or_data'] == 'structure'
 853             || $GLOBALS[$what . '_structure_or_data'] == 'structure_and_data'
 854         ) {
 855             if (! $export_plugin->exportStructure(
 856                 $db, $table, $crlf, $err_url,
 857                 'triggers', $export_type,
 858                 $do_relation, $do_comments, $do_mime, $do_dates
 859             )) {
 860                 break 2;
 861             }
 862         }
 863         if (! $export_plugin->exportDBFooter($db)) {
 864             break;
 865         }
 866     }
 867     if (! $export_plugin->exportFooter()) {
 868         break;
 869     }
 870
 871 } while (false);
 872 // End of fake loop
 873
 874 if ($save_on_server && isset($message)) {
 875     if ($export_type == 'server') {
 876         $active_page = 'server_export.php';
 877         include 'server_export.php';
 878     } elseif ($export_type == 'database') {
 879         $active_page = 'db_export.php';
 880         include 'db_export.php';
 881     } else {
 882         $active_page = 'tbl_export.php';
 883         include 'tbl_export.php';
 884     }
 885     exit();
 886 }
 887
 888 /**
 889  * Send the dump as a file...
 890  */
 891 if (! empty($asfile)) {
 892     // Convert the charset if required.
 893     if ($output_charset_conversion) {
 894         $dump_buffer = PMA_convert_string(
 895             'utf-8',
 896             $GLOBALS['charset_of_file'],
 897             $dump_buffer
 898         );
 899     }
 900
 901     // Do the compression
 902     // 1. as a zipped file
 903     if ($compression == 'zip') {
 904         if (@function_exists('gzcompress')) {
 905             $zipfile = new ZipFile();
 906             $zipfile->addFile($dump_buffer, substr($filename, 0, -4));
 907             $dump_buffer = $zipfile->file();
 908         }
 909     } elseif ($compression == 'bzip2') {
 910         // 2. as a bzipped file
 911         if (@function_exists('bzcompress')) {
 912             $dump_buffer = bzcompress($dump_buffer);
 913         }
 914     } elseif ($compression == 'gzip' && PMA_gzencodeNeeded()) {
 915         // 3. as a gzipped file
 916         // without the optional parameter level because it bugs
 917             $dump_buffer = gzencode($dump_buffer);
 918     }
 919
 920     /* If we saved on server, we have to close file now */
 921     if ($save_on_server) {
 922         $write_result = @fwrite($file_handle, $dump_buffer);
 923         fclose($file_handle);
 924         if (strlen($dump_buffer) > 0
 925             && (! $write_result || ($write_result != strlen($dump_buffer)))
 926         ) {
 927             $message = new PMA_Message(
 928                 __('Insufficient space to save the file %s.'),
 929                 PMA_Message::ERROR,
 930                 $save_filename
 931             );
 932         } else {
 933             $message = new PMA_Message(
 934                 __('Dump has been saved to file %s.'),
 935                 PMA_Message::SUCCESS,
 936                 $save_filename
 937             );
 938         }
 939
 940         if ($export_type == 'server') {
 941             $active_page = 'server_export.php';
 942             include_once 'server_export.php';
 943         } elseif ($export_type == 'database') {
 944             $active_page = 'db_export.php';
 945             include_once 'db_export.php';
 946         } else {
 947             $active_page = 'tbl_export.php';
 948             include_once 'tbl_export.php';
 949         }
 950         exit();
 951     } else {
 952         PMA_Response::getInstance()->disable();
 953         echo $dump_buffer;
 954     }
 955 } else {
 956     /**
 957      * Displays the dump...
 958      *
 959      * Close the html tags and add the footers if dump is displayed on screen
 960      */
 961     echo '</textarea>' . "\n"
 962        . '    </form>' . "\n";
 963     echo $back_button;
 964
 965     echo "\n";
 966     echo '</div>' . "\n";
 967     echo "\n";
 968 ?>
 969 <script type="text/javascript">
 970 //<![CDATA[
 971     var $body = $("body");
 972     $("#textSQLDUMP")
 973         .width($body.width() - 50)
 974         .height($body.height() - 100);
 975 //]]>
 976 </script>
 977 <?php
 978 } // end if
 979 ?>