From 0f5706a3f39d684212345549bdfec05a42f8602a Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Tue, 21 Sep 2004 08:40:18 +0000
Subject: [PATCH] Working but unpolished script to convert all MySQL tables to
 InnoDB format

Not linked, just call it directly
---
 admin/innodb.php | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100644 admin/innodb.php

diff --git a/admin/innodb.php b/admin/innodb.php
new file mode 100644
index 0000000000..bd1eb670f6
--- /dev/null
+++ b/admin/innodb.php
@@ -0,0 +1,29 @@
+<?php
+
+   include('config.php');
+
+   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) {
+
+       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("Are you sure you want convert all your tables to the InnoDB format?", "innodb.php?confirm=yes", "index.php");
+   }
+
+?>
-- 
2.39.5