2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * handles miscellaneous db operations:
10 * - viewing PDF schemas
18 require_once 'libraries/common.inc.php';
19 require_once 'libraries/mysql_charsets.inc.php';
22 * functions implementation for this script
24 require_once 'libraries/operations.lib.php';
26 // add a javascript file for jQuery functions to handle Ajax actions
27 $response = PMA_Response
::getInstance();
28 $header = $response->getHeader();
29 $scripts = $header->getScripts();
30 $scripts->addFile('db_operations.js');
35 * Rename/move or copy database
37 /** @var PMA_String $pmaString */
38 $pmaString = $GLOBALS['PMA_String'];
39 if (/*overload*/mb_strlen($GLOBALS['db'])
40 && (! empty($_REQUEST['db_rename']) ||
! empty($_REQUEST['db_copy']))
42 if (! empty($_REQUEST['db_rename'])) {
48 if (! isset($_REQUEST['newname'])
49 ||
! /*overload*/mb_strlen($_REQUEST['newname'])
51 $message = PMA_Message
::error(__('The database name is empty!'));
54 if ($move ||
! empty($_REQUEST['create_database_before_copying'])) {
55 PMA_createDbBeforeCopy();
58 // here I don't use DELIMITER because it's not part of the
59 // language; I have to send each statement one by one
61 // to avoid selecting alternatively the current and new db
62 // we would need to modify the CREATE definitions to qualify
64 PMA_runProcedureAndFunctionDefinitions($GLOBALS['db']);
66 // go back to current db, just in case
67 $GLOBALS['dbi']->selectDb($GLOBALS['db']);
69 $tables_full = $GLOBALS['dbi']->getTablesFull($GLOBALS['db']);
71 include_once "libraries/plugin_interface.lib.php";
72 // remove all foreign key constraints, otherwise we can get errors
73 $export_sql_plugin = PMA_getPlugin(
76 'libraries/plugins/export/',
78 'single_table' => isset($single_table),
79 'export_type' => 'database'
83 // create stand-in tables for views
84 $views = PMA_getViewsAndCreateSqlViewStandIn(
85 $tables_full, $export_sql_plugin, $GLOBALS['db']
89 $sqlConstratints = PMA_copyTables(
90 $tables_full, $move, $GLOBALS['db']
95 PMA_handleTheViews($views, $move, $GLOBALS['db']);
99 // now that all tables exist, create all the accumulated constraints
100 if (! $_error && count($sqlConstratints) > 0) {
101 PMA_createAllAccumulatedConstraints($sqlConstratints);
103 unset($sqlConstratints);
105 if (! PMA_DRIZZLE
&& PMA_MYSQL_INT_VERSION
>= 50100) {
106 // here DELIMITER is not used because it's not part of the
107 // language; each statement is sent one by one
109 PMA_runEventDefinitionsForDb($GLOBALS['db']);
112 // go back to current db, just in case
113 $GLOBALS['dbi']->selectDb($GLOBALS['db']);
115 // Duplicate the bookmarks for this db (done once for each db)
116 PMA_duplicateBookmarks($_error, $GLOBALS['db']);
118 if (! $_error && $move) {
120 * cleanup pmadb stuff for this db
122 include_once 'libraries/relation_cleanup.lib.php';
123 PMA_relationsCleanupDatabase($GLOBALS['db']);
125 // if someday the RENAME DATABASE reappears, do not DROP
126 $local_query = 'DROP DATABASE '
127 . PMA_Util
::backquote($GLOBALS['db']) . ';';
128 $sql_query .= "\n" . $local_query;
129 $GLOBALS['dbi']->query($local_query);
131 $message = PMA_Message
::success(
132 __('Database %1$s has been renamed to %2$s.')
134 $message->addParam($GLOBALS['db']);
135 $message->addParam($_REQUEST['newname']);
136 } elseif (! $_error) {
137 $message = PMA_Message
::success(
138 __('Database %1$s has been copied to %2$s.')
140 $message->addParam($GLOBALS['db']);
141 $message->addParam($_REQUEST['newname']);
143 $message = PMA_Message
::error();
147 /* Change database to be used */
148 if (! $_error && $move) {
149 $GLOBALS['db'] = $_REQUEST['newname'];
150 } elseif (! $_error) {
151 if (isset($_REQUEST['switch_to_new'])
152 && $_REQUEST['switch_to_new'] == 'true'
154 $GLOBALS['PMA_Config']->setCookie('pma_switch_to_new', 'true');
155 $GLOBALS['db'] = $_REQUEST['newname'];
157 $GLOBALS['PMA_Config']->setCookie('pma_switch_to_new', '');
163 * Database has been successfully renamed/moved. If in an Ajax request,
164 * generate the output with {@link PMA_Response} and exit
166 if ($GLOBALS['is_ajax_request'] == true) {
167 $response = PMA_Response
::getInstance();
168 $response->isSuccess($message->isSuccess());
169 $response->addJSON('message', $message);
170 $response->addJSON('newname', $_REQUEST['newname']);
173 PMA_Util
::getMessage(null, $sql_query)
175 $response->addJSON('db', $GLOBALS['db']);
181 * Settings for relations stuff
184 $cfgRelation = PMA_getRelationsParam();
187 * Check if comments were updated
188 * (must be done before displaying the menu tabs)
190 if (isset($_REQUEST['comment'])) {
191 PMA_setDbComment($GLOBALS['db'], $_REQUEST['comment']);
194 require 'libraries/db_common.inc.php';
195 $url_query .= '&goto=db_operations.php';
197 // Gets the database structure
198 $sub_part = '_structure';
199 require 'libraries/db_info.inc.php';
202 if (isset($message)) {
203 echo PMA_Util
::getMessage($message, $sql_query);
207 $_REQUEST['db_collation'] = PMA_getDbCollation($GLOBALS['db']);
208 $is_information_schema = $GLOBALS['dbi']->isSystemSchema($GLOBALS['db']);
210 $response->addHTML('<div id="boxContainer" data-box-width="300">');
212 if (!$is_information_schema) {
213 if ($cfgRelation['commwork']) {
217 $response->addHTML(PMA_getHtmlForDatabaseComment($GLOBALS['db']));
220 $response->addHTML('<div class="operations_half_width">');
222 include 'libraries/display_create_table.lib.php';
223 $content = ob_get_contents();
225 $response->addHTML($content);
226 $response->addHTML('</div>');
231 if ($GLOBALS['db'] != 'mysql') {
232 $response->addHTML(PMA_getHtmlForRenameDatabase($GLOBALS['db']));
235 // Drop link if allowed
236 // Don't even try to drop information_schema.
237 // You won't be able to. Believe me. You won't.
238 // Don't allow to easily drop mysql database, RFE #1327514.
239 if (($is_superuser ||
$GLOBALS['cfg']['AllowUserDropDatabase'])
240 && ! $db_is_system_schema
241 && (PMA_DRIZZLE ||
$GLOBALS['db'] != 'mysql')
243 $response->addHTML(PMA_getHtmlForDropDatabaseLink($GLOBALS['db']));
248 $response->addHTML(PMA_getHtmlForCopyDatabase($GLOBALS['db']));
251 * Change database charset
253 $response->addHTML(PMA_getHtmlForChangeDatabaseCharset($GLOBALS['db'], $table));
255 if (! $cfgRelation['allworks']
256 && $cfg['PmaNoRelation_DisableWarning'] == false
258 $message = PMA_Message
::notice(
259 __('The phpMyAdmin configuration storage has been deactivated. %sFind out why%s.')
262 '<a href="' . $cfg['PmaAbsoluteUri']
263 . 'chk_rel.php' . $url_query . '">',
266 $message->addParam('</a>', false);
267 /* Show error if user has configured something, notice elsewhere */
268 if (!empty($cfg['Servers'][$server]['pmadb'])) {
269 $message->isError(true);
272 } // end if (!$is_information_schema)
274 $response->addHTML('</div>');
276 // not sure about displaying the PDF dialog in case db is information_schema
277 if ($cfgRelation['pdfwork'] && $num_tables > 0) {
278 // We only show this if we find something in the new pdf_pages table
281 FROM ' . PMA_Util
::backquote($GLOBALS['cfgRelation']['db'])
282 . '.' . PMA_Util
::backquote($cfgRelation['pdf_pages']) . '
283 WHERE db_name = \'' . PMA_Util
::sqlAddSlashes($GLOBALS['db']) . '\'';
284 $test_rs = PMA_queryAsControlUser(
287 PMA_DatabaseInterface
::QUERY_STORE