admin/innodb.php

   1 <?php
   2
   3    require_once('../config.php');
   4    require_once($CFG->libdir.'/adminlib.php');
   5
   6    admin_externalpage_setup('toinodb');
   7
   8    $confirm = optional_param('confirm', 0, PARAM_BOOL);
   9
  10    require_login();
  11
  12    require_capability('moodle/site:config', get_context_instance(CONTEXT_SYSTEM, SITEID));
  13
  14    admin_externalpage_print_header();
  15    print_heading('Convert all MySQL tables from MYISAM to InnoDB');
  16
  17    if ($CFG->dbfamily != 'mysql') {
  18         notice('This function is for MySQL databases only!', 'index.php');
  19    }
  20
  21    if (data_submitted() and $confirm and confirm_sesskey()) {
  22
  23        notify('Please be patient and wait for this to complete...', 'notifysuccess');
  24
  25        if ($tables = $db->MetaTables()) {
  26            $db->debug = true;
  27            foreach ($tables as $table) {
  28                execute_sql("ALTER TABLE $table TYPE=INNODB; ");
  29            }
  30            $db->debug = false;
  31        }
  32        notify('... done.', 'notifysuccess');
  33        print_continue('index.php');
  34        admin_externalpage_print_footer();
  35
  36    } else {
  37        $optionsyes = array('confirm'=>'1', 'sesskey'=>sesskey());
  38        notice_yesno('Are you sure you want convert all your tables to the InnoDB format?',
  39                     'innodb.php', 'index.php', $optionsyes, NULL, 'post', 'get');
  40        admin_externalpage_print_footer();
  41    }
  42
  43 ?>