<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * dumps a database * * @package PhpMyAdmin */ use PMA\libraries\config\PageSettings; use PMA\libraries\Response; /** * Gets some core libraries */ require_once 'libraries/common.inc.php'; require_once 'libraries/config/user_preferences.forms.php'; require_once 'libraries/config/page_settings.forms.php'; require_once 'libraries/export.lib.php'; PageSettings::showGroup('Export'); $response = Response::getInstance(); $header = $response->getHeader(); $scripts = $header->getScripts(); $scripts->addFile('export.js'); // $sub_part is used in PMA\libraries\Util::getDbInfo() to see if we are coming from // db_export.php, in which case we don't obey $cfg['MaxTableList'] $sub_part = '_export'; require_once 'libraries/db_common.inc.php'; $url_query .= '&goto=db_export.php'; list( $tables, $num_tables, $total_num_tables, $sub_part, $is_show_stats, $db_is_system_schema, $tooltip_truename, $tooltip_aliasname, $pos ) = PMA\libraries\Util::getDbInfo($db, isset($sub_part) ? $sub_part : ''); /** * Displays the form */ $export_page_title = __('View dump (schema) of database'); // exit if no tables in db found if ($num_tables < 1) { PMA\libraries\Message::error(__('No tables found in database.'))->display(); exit; } // end if $multi_values = '<div class="export_table_list_container">'; if (isset($_GET['structure_or_data_forced'])) { $force_val = htmlspecialchars($_GET['structure_or_data_forced']); } else { $force_val = 0; } $multi_values .= '<input type="hidden" name="structure_or_data_forced" value="' . $force_val . '">'; $multi_values .= '<table class="export_table_select">' . '<thead><tr><th></th>' . '<th>' . __('Tables') . '</th>' . '<th class="export_structure">' . __('Structure') . '</th>' . '<th class="export_data">' . __('Data') . '</th>' . '</tr><tr>' . '<td></td>' . '<td class="export_table_name all">' . __('Select all') . '</td>' . '<td class="export_structure all">' . '<input type="checkbox" id="table_structure_all" /></td>' . '<td class="export_data all"><input type="checkbox" id="table_data_all" />' . '</td>' . '</tr></thead>' . '<tbody>'; $multi_values .= "\n"; // when called by libraries/mult_submits.inc.php if (!empty($_POST['selected_tbl']) && empty($table_select)) { $table_select = $_POST['selected_tbl']; } // Check if the selected tables are defined in $_GET // (from clicking Back button on export.php) foreach (array('table_select', 'table_structure', 'table_data') as $one_key) { if (isset($_GET[$one_key])) { $_GET[$one_key] = urldecode($_GET[$one_key]); $_GET[$one_key] = explode(",", $_GET[$one_key]); } } foreach ($tables as $each_table) { if (isset($_GET['table_select']) && is_array($_GET['table_select'])) { $is_checked = PMA_getCheckedClause( $each_table['Name'], $_GET['table_select'] ); } elseif (isset($table_select)) { $is_checked = PMA_getCheckedClause( $each_table['Name'], $table_select ); } else { $is_checked = ' checked="checked"'; } if (isset($_GET['table_structure']) && is_array($_GET['table_structure'])) { $structure_checked = PMA_getCheckedClause( $each_table['Name'], $_GET['table_structure'] ); } else { $structure_checked = $is_checked; } if (isset($_GET['table_data']) && is_array($_GET['table_data'])) { $data_checked = PMA_getCheckedClause( $each_table['Name'], $_GET['table_data'] ); } else { $data_checked = $is_checked; } $table_html = htmlspecialchars($each_table['Name']); $multi_values .= '<tr>'; $multi_values .= '<td><input type="checkbox" name="table_select[]"' . ' value="' . $table_html . '"' . $is_checked . ' /></td>'; $multi_values .= '<td class="export_table_name">' . str_replace(' ', ' ', $table_html) . '</td>'; $multi_values .= '<td class="export_structure">' . '<input type="checkbox" name="table_structure[]"' . ' value="' . $table_html . '"' . $structure_checked . ' /></td>'; $multi_values .= '<td class="export_data">' . '<input type="checkbox" name="table_data[]"' . ' value="' . $table_html . '"' . $data_checked . ' /></td>'; $multi_values .= '</tr>'; } // end for $multi_values .= "\n"; $multi_values .= '</tbody></table></div>'; require_once 'libraries/display_export.lib.php'; if (! isset($sql_query)) { $sql_query = ''; } if (! isset($num_tables)) { $num_tables = 0; } if (! isset($unlim_num_rows)) { $unlim_num_rows = 0; } if (! isset($multi_values)) { $multi_values = ''; } $response = Response::getInstance(); $response->addHTML( PMA_getExportDisplay( 'database', $db, $table, $sql_query, $num_tables, $unlim_num_rows, $multi_values ) );
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
doc | Folder | 0755 |
|
|
js | Folder | 0755 |
|
|
libraries | Folder | 0755 |
|
|
locale | Folder | 0755 |
|
|
setup | Folder | 0755 |
|
|
sql | Folder | 0755 |
|
|
templates | Folder | 0755 |
|
|
themes | Folder | 0755 |
|
|
browse_foreigners.php | File | 1.55 KB | 0644 |
|
changelog.php | File | 5.18 KB | 0644 |
|
chk_rel.php | File | 758 B | 0644 |
|
config.sample.inc.php | File | 4.45 KB | 0644 |
|
db_central_columns.php | File | 5.25 KB | 0644 |
|
db_datadict.php | File | 5.76 KB | 0644 |
|
db_designer.php | File | 5.72 KB | 0644 |
|
db_events.php | File | 356 B | 0644 |
|
db_export.php | File | 4.85 KB | 0644 |
|
db_import.php | File | 1.02 KB | 0644 |
|
db_operations.php | File | 9.68 KB | 0644 |
|
db_qbe.php | File | 4.33 KB | 0644 |
|
db_routines.php | File | 465 B | 0644 |
|
db_search.php | File | 2.03 KB | 0644 |
|
db_sql.php | File | 1.07 KB | 0644 |
|
db_sql_autocomplete.php | File | 735 B | 0644 |
|
db_sql_format.php | File | 463 B | 0644 |
|
db_structure.php | File | 1.04 KB | 0644 |
|
db_tracking.php | File | 4.32 KB | 0644 |
|
db_triggers.php | File | 360 B | 0644 |
|
error_report.php | File | 4.48 KB | 0644 |
|
export.php | File | 17.17 KB | 0644 |
|
favicon.ico | File | 21.96 KB | 0644 |
|
file_echo.php | File | 856 B | 0644 |
|
gis_data_editor.php | File | 15.46 KB | 0644 |
|
import.php | File | 28.7 KB | 0644 |
|
import_status.php | File | 3.38 KB | 0644 |
|
index.php | File | 20.32 KB | 0644 |
|
license.php | File | 852 B | 0644 |
|
lint.php | File | 1.35 KB | 0644 |
|
logout.php | File | 247 B | 0644 |
|
navigation.php | File | 2.13 KB | 0644 |
|
normalization.php | File | 3.93 KB | 0644 |
|
phpinfo.php | File | 510 B | 0644 |
|
phpmyadmin.css.php | File | 1017 B | 0644 |
|
prefs_forms.php | File | 2.68 KB | 0644 |
|
prefs_manage.php | File | 14.35 KB | 0644 |
|
print.css | File | 1.18 KB | 0644 |
|
schema_export.php | File | 1.64 KB | 0644 |
|
server_binlog.php | File | 804 B | 0644 |
|
server_collations.php | File | 837 B | 0644 |
|
server_databases.php | File | 817 B | 0644 |
|
server_engines.php | File | 803 B | 0644 |
|
server_export.php | File | 1.2 KB | 0644 |
|
server_import.php | File | 793 B | 0644 |
|
server_plugins.php | File | 808 B | 0644 |
|
server_privileges.php | File | 13.66 KB | 0644 |
|
server_replication.php | File | 2.14 KB | 0644 |
|
server_sql.php | File | 847 B | 0644 |
|
server_status.php | File | 981 B | 0644 |
|
server_status_advisor.php | File | 940 B | 0644 |
|
server_status_monitor.php | File | 3.01 KB | 0644 |
|
server_status_processes.php | File | 1.89 KB | 0644 |
|
server_status_queries.php | File | 1.35 KB | 0644 |
|
server_status_variables.php | File | 1.58 KB | 0644 |
|
server_user_groups.php | File | 1.79 KB | 0644 |
|
server_variables.php | File | 817 B | 0644 |
|
show_config_errors.php | File | 1.02 KB | 0644 |
|
sql.php | File | 6.24 KB | 0644 |
|
tbl_addfield.php | File | 3.79 KB | 0644 |
|
tbl_change.php | File | 6.6 KB | 0644 |
|
tbl_chart.php | File | 990 B | 0644 |
|
tbl_create.php | File | 3.09 KB | 0644 |
|
tbl_export.php | File | 4.27 KB | 0644 |
|
tbl_find_replace.php | File | 1.01 KB | 0644 |
|
tbl_get_field.php | File | 1.64 KB | 0644 |
|
tbl_gis_visualization.php | File | 1.23 KB | 0644 |
|
tbl_import.php | File | 910 B | 0644 |
|
tbl_indexes.php | File | 1.4 KB | 0644 |
|
tbl_operations.php | File | 14.12 KB | 0644 |
|
tbl_recent_favorite.php | File | 455 B | 0644 |
|
tbl_relation.php | File | 2.47 KB | 0644 |
|
tbl_replace.php | File | 16.27 KB | 0644 |
|
tbl_row_action.php | File | 4.95 KB | 0644 |
|
tbl_select.php | File | 1.14 KB | 0644 |
|
tbl_sql.php | File | 1.24 KB | 0644 |
|
tbl_structure.php | File | 1.72 KB | 0644 |
|
tbl_tracking.php | File | 5.82 KB | 0644 |
|
tbl_triggers.php | File | 141 B | 0644 |
|
tbl_zoom_select.php | File | 1.06 KB | 0644 |
|
themes.php | File | 894 B | 0644 |
|
transformation_overview.php | File | 1.89 KB | 0644 |
|
transformation_wrapper.php | File | 4.67 KB | 0644 |
|
url.php | File | 1.29 KB | 0644 |
|
user_password.php | File | 9.29 KB | 0644 |
|
version_check.php | File | 1.04 KB | 0644 |
|
view_create.php | File | 9.2 KB | 0644 |
|
view_operations.php | File | 3.79 KB | 0644 |
|