. /** * InnoDB conversion tool. * * @package tool * @subpackage innodb * @copyright 1999 onwards Martin Dougiamas (http://dougiamas.com) * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ define('NO_OUTPUT_BUFFERING', true); require_once('../../../config.php'); require_once($CFG->libdir.'/adminlib.php'); admin_externalpage_setup('toolinnodb'); $confirm = optional_param('confirm', 0, PARAM_BOOL); require_login(); require_capability('moodle/site:config', get_context_instance(CONTEXT_SYSTEM)); echo $OUTPUT->header(); echo $OUTPUT->heading('Convert all MySQL tables from MYISAM to InnoDB'); if ($DB->get_dbfamily() != 'mysql') { notice('This function is for MySQL databases only!', new moodle_url('/admin/')); } if (data_submitted() and $confirm and confirm_sesskey()) { echo $OUTPUT->notification('Please be patient and wait for this to complete...', 'notifysuccess'); set_time_limit(0); if ($tables = $DB->get_tables()) { $DB->set_debug(true); foreach ($tables as $table) { $fulltable = $DB->get_prefix().$table; try { $DB->change_database_structure("ALTER TABLE $fulltable ENGINE=INNODB"); } catch (moodle_exception $e) { echo $OUTPUT->notification(s($e->getMessage()).'
'.s($e->debuginfo)); } } $DB->set_debug(false); } echo $OUTPUT->notification('... done.', 'notifysuccess'); echo $OUTPUT->continue_button(new moodle_url('/admin/')); echo $OUTPUT->footer(); } else { $optionsyes = array('confirm'=>'1', 'sesskey'=>sesskey()); $formcontinue = new single_button(new moodle_url('/admin/tool/innodb/index.php', $optionsyes), get_string('yes')); $formcancel = new single_button(new moodle_url('/admin/'), get_string('no'), 'get'); echo $OUTPUT->confirm('Are you sure you want convert all your tables to the InnoDB format?', $formcontinue, $formcancel); echo $OUTPUT->footer(); }