admin/innodb.php

   1 <?php
   2
   3    require_once('../config.php');
   4
   5    $confirm = optional_param('confirm', 0, PARAM_BOOL);
   6
   7    require_login();
   8
   9    if (!isadmin()) {
  10        error('Admin only');
  11    }
  12
  13    print_header("Convert all tables from MYISAM to InnoDB", "Convert all tables from MYISAM to InnoDB",
  14                 "Convert all tables from MYISAM to InnoDB");
  15
  16
  17    if ($confirm and confirm_sesskey()) {
  18
  19        print_heading("Please be patient and wait for this to complete...");
  20
  21        if ($tables = $db->MetaTables()) {
  22            $db->debug = true;
  23            foreach ($tables as $table) {
  24                execute_sql("ALTER TABLE $table TYPE=INNODB; ");
  25            }
  26        }
  27    } else {
  28        notice_yesno("Are you sure you want convert all your tables to the InnoDB format?",
  29                     "innodb.php?confirm=1&sesskey=".sesskey(), "index.php");
  30    }
  31
  32 ?>