db_operations.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * handles miscellaneous db operations:
   5  *  - move/rename
   6  *  - copy
   7  *  - changing collation
   8  *  - changing comment
   9  *  - adding tables
  10  *  - viewing PDF schemas
  11  *
  12  * @package PhpMyAdmin
  13  */
  14 use PMA\libraries\plugins\export\ExportSql;
  15
  16 /**
  17  * requirements
  18  */
  19 require_once 'libraries/common.inc.php';
  20 require_once 'libraries/mysql_charsets.inc.php';
  21 require_once 'libraries/display_create_table.lib.php';
  22
  23 /**
  24  * functions implementation for this script
  25  */
  26 require_once 'libraries/check_user_privileges.lib.php';
  27 require_once 'libraries/operations.lib.php';
  28
  29 // add a javascript file for jQuery functions to handle Ajax actions
  30 $response = PMA\libraries\Response::getInstance();
  31 $header = $response->getHeader();
  32 $scripts = $header->getScripts();
  33 $scripts->addFile('db_operations.js');
  34
  35 $sql_query = '';
  36
  37 /**
  38  * Rename/move or copy database
  39  */
  40 if (mb_strlen($GLOBALS['db'])
  41     && (! empty($_REQUEST['db_rename']) || ! empty($_REQUEST['db_copy']))
  42 ) {
  43     if (! empty($_REQUEST['db_rename'])) {
  44         $move = true;
  45     } else {
  46         $move = false;
  47     }
  48
  49     if (! isset($_REQUEST['newname'])
  50         || ! mb_strlen($_REQUEST['newname'])
  51     ) {
  52         $message = PMA\libraries\Message::error(__('The database name is empty!'));
  53     } else {
  54         $_error = false;
  55         if ($move || ! empty($_REQUEST['create_database_before_copying'])) {
  56             PMA_createDbBeforeCopy();
  57         }
  58
  59         // here I don't use DELIMITER because it's not part of the
  60         // language; I have to send each statement one by one
  61
  62         // to avoid selecting alternatively the current and new db
  63         // we would need to modify the CREATE definitions to qualify
  64         // the db name
  65         PMA_runProcedureAndFunctionDefinitions($GLOBALS['db']);
  66
  67         // go back to current db, just in case
  68         $GLOBALS['dbi']->selectDb($GLOBALS['db']);
  69
  70         $tables_full = $GLOBALS['dbi']->getTablesFull($GLOBALS['db']);
  71
  72         include_once "libraries/plugin_interface.lib.php";
  73         // remove all foreign key constraints, otherwise we can get errors
  74         /* @var $export_sql_plugin ExportSql */
  75         $export_sql_plugin = PMA_getPlugin(
  76             "export",
  77             "sql",
  78             'libraries/plugins/export/',
  79             array(
  80                 'single_table' => isset($single_table),
  81                 'export_type'  => 'database'
  82             )
  83         );
  84
  85         // create stand-in tables for views
  86         $views = PMA_getViewsAndCreateSqlViewStandIn(
  87             $tables_full, $export_sql_plugin, $GLOBALS['db']
  88         );
  89
  90         // copy tables
  91         $sqlConstratints = PMA_copyTables(
  92             $tables_full, $move, $GLOBALS['db']
  93         );
  94
  95         // handle the views
  96         if (! $_error) {
  97             PMA_handleTheViews($views, $move, $GLOBALS['db']);
  98         }
  99         unset($views);
 100
 101         // now that all tables exist, create all the accumulated constraints
 102         if (! $_error && count($sqlConstratints) > 0) {
 103             PMA_createAllAccumulatedConstraints($sqlConstratints);
 104         }
 105         unset($sqlConstratints);
 106
 107         if (PMA_MYSQL_INT_VERSION >= 50100) {
 108             // here DELIMITER is not used because it's not part of the
 109             // language; each statement is sent one by one
 110
 111             PMA_runEventDefinitionsForDb($GLOBALS['db']);
 112         }
 113
 114         // go back to current db, just in case
 115         $GLOBALS['dbi']->selectDb($GLOBALS['db']);
 116
 117         // Duplicate the bookmarks for this db (done once for each db)
 118         PMA_duplicateBookmarks($_error, $GLOBALS['db']);
 119
 120         if (! $_error && $move) {
 121             if (isset($_REQUEST['adjust_privileges'])
 122                 && ! empty($_REQUEST['adjust_privileges'])
 123             ) {
 124                 PMA_AdjustPrivileges_moveDB($GLOBALS['db'], $_REQUEST['newname']);
 125             }
 126
 127             /**
 128              * cleanup pmadb stuff for this db
 129              */
 130             include_once 'libraries/relation_cleanup.lib.php';
 131             PMA_relationsCleanupDatabase($GLOBALS['db']);
 132
 133             // if someday the RENAME DATABASE reappears, do not DROP
 134             $local_query = 'DROP DATABASE '
 135                 . PMA\libraries\Util::backquote($GLOBALS['db']) . ';';
 136             $sql_query .= "\n" . $local_query;
 137             $GLOBALS['dbi']->query($local_query);
 138
 139             $message = PMA\libraries\Message::success(
 140                 __('Database %1$s has been renamed to %2$s.')
 141             );
 142             $message->addParam($GLOBALS['db']);
 143             $message->addParam($_REQUEST['newname']);
 144         } elseif (! $_error) {
 145             if (isset($_REQUEST['adjust_privileges'])
 146                 && ! empty($_REQUEST['adjust_privileges'])
 147             ) {
 148                 PMA_AdjustPrivileges_copyDB($GLOBALS['db'], $_REQUEST['newname']);
 149             }
 150
 151             $message = PMA\libraries\Message::success(
 152                 __('Database %1$s has been copied to %2$s.')
 153             );
 154             $message->addParam($GLOBALS['db']);
 155             $message->addParam($_REQUEST['newname']);
 156         } else {
 157             $message = PMA\libraries\Message::error();
 158         }
 159         $reload     = true;
 160
 161         /* Change database to be used */
 162         if (! $_error && $move) {
 163             $GLOBALS['db'] = $_REQUEST['newname'];
 164         } elseif (! $_error) {
 165             if (isset($_REQUEST['switch_to_new'])
 166                 && $_REQUEST['switch_to_new'] == 'true'
 167             ) {
 168                 $GLOBALS['PMA_Config']->setCookie('pma_switch_to_new', 'true');
 169                 $GLOBALS['db'] = $_REQUEST['newname'];
 170             } else {
 171                 $GLOBALS['PMA_Config']->setCookie('pma_switch_to_new', '');
 172             }
 173         }
 174     }
 175
 176     /**
 177      * Database has been successfully renamed/moved.  If in an Ajax request,
 178      * generate the output with {@link PMA\libraries\Response} and exit
 179      */
 180     if ($GLOBALS['is_ajax_request'] == true) {
 181         $response = PMA\libraries\Response::getInstance();
 182         $response->setRequestStatus($message->isSuccess());
 183         $response->addJSON('message', $message);
 184         $response->addJSON('newname', $_REQUEST['newname']);
 185         $response->addJSON(
 186             'sql_query',
 187             PMA\libraries\Util::getMessage(null, $sql_query)
 188         );
 189         $response->addJSON('db', $GLOBALS['db']);
 190         exit;
 191     }
 192 }
 193
 194 /**
 195  * Settings for relations stuff
 196  */
 197
 198 $cfgRelation = PMA_getRelationsParam();
 199
 200 /**
 201  * Check if comments were updated
 202  * (must be done before displaying the menu tabs)
 203  */
 204 if (isset($_REQUEST['comment'])) {
 205     PMA_setDbComment($GLOBALS['db'], $_REQUEST['comment']);
 206 }
 207
 208 require 'libraries/db_common.inc.php';
 209 $url_query .= '&amp;goto=db_operations.php';
 210
 211 // Gets the database structure
 212 $sub_part = '_structure';
 213
 214 list(
 215     $tables,
 216     $num_tables,
 217     $total_num_tables,
 218     $sub_part,
 219     $is_show_stats,
 220     $db_is_system_schema,
 221     $tooltip_truename,
 222     $tooltip_aliasname,
 223     $pos
 224 ) = PMA\libraries\Util::getDbInfo($db, isset($sub_part) ? $sub_part : '');
 225
 226 echo "\n";
 227
 228 if (isset($message)) {
 229     echo PMA\libraries\Util::getMessage($message, $sql_query);
 230     unset($message);
 231 }
 232
 233 $_REQUEST['db_collation'] = PMA_getDbCollation($GLOBALS['db']);
 234 $is_information_schema = $GLOBALS['dbi']->isSystemSchema($GLOBALS['db']);
 235
 236 $response->addHTML('<div id="boxContainer" data-box-width="300">');
 237
 238 if (!$is_information_schema) {
 239     if ($cfgRelation['commwork']) {
 240         /**
 241          * database comment
 242          */
 243         $response->addHTML(PMA_getHtmlForDatabaseComment($GLOBALS['db']));
 244     }
 245
 246     $response->addHTML('<div class="operations_half_width">');
 247     $response->addHTML(PMA_getHtmlForCreateTable($db));
 248     $response->addHTML('</div>');
 249
 250     /**
 251      * rename database
 252      */
 253     if ($GLOBALS['db'] != 'mysql') {
 254         $response->addHTML(PMA_getHtmlForRenameDatabase($GLOBALS['db']));
 255     }
 256
 257     // Drop link if allowed
 258     // Don't even try to drop information_schema.
 259     // You won't be able to. Believe me. You won't.
 260     // Don't allow to easily drop mysql database, RFE #1327514.
 261     if (($is_superuser || $GLOBALS['cfg']['AllowUserDropDatabase'])
 262         && ! $db_is_system_schema
 263         && $GLOBALS['db'] != 'mysql'
 264     ) {
 265         $response->addHTML(PMA_getHtmlForDropDatabaseLink($GLOBALS['db']));
 266     }
 267     /**
 268      * Copy database
 269      */
 270     $response->addHTML(PMA_getHtmlForCopyDatabase($GLOBALS['db']));
 271
 272     /**
 273      * Change database charset
 274      */
 275     $response->addHTML(PMA_getHtmlForChangeDatabaseCharset($GLOBALS['db'], $table));
 276
 277     if (! $cfgRelation['allworks']
 278         && $cfg['PmaNoRelation_DisableWarning'] == false
 279     ) {
 280         $message = PMA\libraries\Message::notice(
 281             __(
 282                 'The phpMyAdmin configuration storage has been deactivated. ' .
 283                 '%sFind out why%s.'
 284             )
 285         );
 286         $message->addParam(
 287             '<a href="'
 288             . './chk_rel.php' . $url_query . '">',
 289             false
 290         );
 291         $message->addParam('</a>', false);
 292         /* Show error if user has configured something, notice elsewhere */
 293         if (!empty($cfg['Servers'][$server]['pmadb'])) {
 294             $message->isError(true);
 295         }
 296     } // end if
 297 } // end if (!$is_information_schema)
 298
 299 $response->addHTML('</div>');
 300
 301 // not sure about displaying the PDF dialog in case db is information_schema
 302 if ($cfgRelation['pdfwork'] && $num_tables > 0) {
 303     // We only show this if we find something in the new pdf_pages table
 304     $test_query = '
 305         SELECT *
 306         FROM ' . PMA\libraries\Util::backquote($GLOBALS['cfgRelation']['db'])
 307         . '.' . PMA\libraries\Util::backquote($cfgRelation['pdf_pages']) . '
 308         WHERE db_name = \'' . PMA\libraries\Util::sqlAddSlashes($GLOBALS['db'])
 309         . '\'';
 310     $test_rs = PMA_queryAsControlUser(
 311         $test_query,
 312         false,
 313         PMA\libraries\DatabaseInterface::QUERY_STORE
 314     );
 315 } // end if