File: innodb.php

package info (click to toggle)
moodle 1.6.3-2%2Betch3
  • links: PTS
  • area: main
  • in suites: etch
  • size: 37,172 kB
  • ctags: 51,688
  • sloc: php: 231,916; sql: 5,631; xml: 2,688; sh: 1,185; perl: 638; makefile: 48; pascal: 36
file content (32 lines) | stat: -rw-r--r-- 851 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
 
<?php

   require_once('../config.php');

   $confirm = optional_param('confirm', 0, PARAM_BOOL);

   require_login();

   if (!isadmin()) {
       error('Admin only');
   }

   print_header("Convert all tables from MYISAM to InnoDB", "Convert all tables from MYISAM to InnoDB", 
                "Convert all tables from MYISAM to InnoDB");


   if ($confirm and confirm_sesskey()) {

       print_heading("Please be patient and wait for this to complete...");

       if ($tables = $db->MetaTables()) {
           $db->debug = true;
           foreach ($tables as $table) {
               execute_sql("ALTER TABLE $table TYPE=INNODB; ");
           }
       }
   } else {
       notice_yesno("Are you sure you want convert all your tables to the InnoDB format?", 
                    "innodb.php?confirm=1&sesskey=".sesskey(), "index.php");
   }

?>