getHeader(); $scripts = $header->getScripts(); $scripts->addFile('db_operations.js'); $sql_query = ''; /** * Rename/move or copy database */ if (strlen($GLOBALS['db'] > 0) && (! empty($_REQUEST['db_rename']) || ! empty($_REQUEST['db_copy'])) ) { if (! empty($_REQUEST['db_rename'])) { $move = true; } else { $move = false; } if (! isset($_REQUEST['newname']) || strlen($_REQUEST['newname']) === 0) { $message = PMA\libraries\Message::error(__('The database name is empty!')); } else { $_error = false; if ($move || ! empty($_REQUEST['create_database_before_copying'])) { PMA_createDbBeforeCopy(); } // here I don't use DELIMITER because it's not part of the // language; I have to send each statement one by one // to avoid selecting alternatively the current and new db // we would need to modify the CREATE definitions to qualify // the db name PMA_runProcedureAndFunctionDefinitions($GLOBALS['db']); // go back to current db, just in case $GLOBALS['dbi']->selectDb($GLOBALS['db']); $tables_full = $GLOBALS['dbi']->getTablesFull($GLOBALS['db']); include_once "libraries/plugin_interface.lib.php"; // remove all foreign key constraints, otherwise we can get errors /* @var $export_sql_plugin ExportSql */ $export_sql_plugin = PMA_getPlugin( "export", "sql", 'libraries/plugins/export/', array( 'single_table' => isset($single_table), 'export_type' => 'database' ) ); // create stand-in tables for views $views = PMA_getViewsAndCreateSqlViewStandIn( $tables_full, $export_sql_plugin, $GLOBALS['db'] ); // copy tables $sqlConstratints = PMA_copyTables( $tables_full, $move, $GLOBALS['db'] ); // handle the views if (! $_error) { PMA_handleTheViews($views, $move, $GLOBALS['db']); } unset($views); // now that all tables exist, create all the accumulated constraints if (! $_error && count($sqlConstratints) > 0) { PMA_createAllAccumulatedConstraints($sqlConstratints); } unset($sqlConstratints); if (PMA_MYSQL_INT_VERSION >= 50100) { // here DELIMITER is not used because it's not part of the // language; each statement is sent one by one PMA_runEventDefinitionsForDb($GLOBALS['db']); } // go back to current db, just in case $GLOBALS['dbi']->selectDb($GLOBALS['db']); // Duplicate the bookmarks for this db (done once for each db) PMA_duplicateBookmarks($_error, $GLOBALS['db']); if (! $_error && $move) { if (isset($_REQUEST['adjust_privileges']) && ! empty($_REQUEST['adjust_privileges']) ) { PMA_AdjustPrivileges_moveDB($GLOBALS['db'], $_REQUEST['newname']); } /** * cleanup pmadb stuff for this db */ include_once 'libraries/relation_cleanup.lib.php'; PMA_relationsCleanupDatabase($GLOBALS['db']); // if someday the RENAME DATABASE reappears, do not DROP $local_query = 'DROP DATABASE ' . PMA\libraries\Util::backquote($GLOBALS['db']) . ';'; $sql_query .= "\n" . $local_query; $GLOBALS['dbi']->query($local_query); $message = PMA\libraries\Message::success( __('Database %1$s has been renamed to %2$s.') ); $message->addParam($GLOBALS['db']); $message->addParam($_REQUEST['newname']); } elseif (! $_error) { if (isset($_REQUEST['adjust_privileges']) && ! empty($_REQUEST['adjust_privileges']) ) { PMA_AdjustPrivileges_copyDB($GLOBALS['db'], $_REQUEST['newname']); } $message = PMA\libraries\Message::success( __('Database %1$s has been copied to %2$s.') ); $message->addParam($GLOBALS['db']); $message->addParam($_REQUEST['newname']); } else { $message = PMA\libraries\Message::error(); } $reload = true; /* Change database to be used */ if (! $_error && $move) { $GLOBALS['db'] = $_REQUEST['newname']; } elseif (! $_error) { if (isset($_REQUEST['switch_to_new']) && $_REQUEST['switch_to_new'] == 'true' ) { $GLOBALS['PMA_Config']->setCookie('pma_switch_to_new', 'true'); $GLOBALS['db'] = $_REQUEST['newname']; } else { $GLOBALS['PMA_Config']->setCookie('pma_switch_to_new', ''); } } } /** * Database has been successfully renamed/moved. If in an Ajax request, * generate the output with {@link PMA\libraries\Response} and exit */ if ($GLOBALS['is_ajax_request'] == true) { $response = PMA\libraries\Response::getInstance(); $response->setRequestStatus($message->isSuccess()); $response->addJSON('message', $message); $response->addJSON('newname', $_REQUEST['newname']); $response->addJSON( 'sql_query', PMA\libraries\Util::getMessage(null, $sql_query) ); $response->addJSON('db', $GLOBALS['db']); exit; } } /** * Settings for relations stuff */ $cfgRelation = PMA_getRelationsParam(); /** * Check if comments were updated * (must be done before displaying the menu tabs) */ if (isset($_REQUEST['comment'])) { PMA_setDbComment($GLOBALS['db'], $_REQUEST['comment']); } require 'libraries/db_common.inc.php'; $url_query .= '&goto=db_operations.php'; // Gets the database structure $sub_part = '_structure'; 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 : ''); echo "\n"; if (isset($message)) { echo PMA\libraries\Util::getMessage($message, $sql_query); unset($message); } $_REQUEST['db_collation'] = $GLOBALS['dbi']->getDbCollation($GLOBALS['db']); $is_information_schema = $GLOBALS['dbi']->isSystemSchema($GLOBALS['db']); $response->addHTML('