Not Solved MyISAM vs InnoDB for MyBB?
#13
Not Solved
Try this:

<?php

define("IN_MYBB", 1);
define("NO_ONLINE", 1);
define("NO_PLUGINS", 1);
require_once "global.php";
if(!$mybb->usergroup['cancp'])
{
error_no_permission();
}
$tablelist = $db->list_tables($config['database']['database'], TABLE_PREFIX);
foreach($tablelist as $table)
{
$db->write_query("ALTER TABLE "  . $table . " ENGINE=Innodb");
echo "Converted table $table to Innodb.<br />";
}
echo "Table conversion complete.<br />";
?>
Reply


Messages In This Thread
MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-11, 07:31 PM
RE: MyISAM vs InnoDB for MyBB? - by dragonexpert - 2016-12-12, 01:03 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-12, 04:15 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-12, 06:48 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-12, 06:50 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-12, 07:12 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-12, 07:21 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-13, 04:56 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-13, 05:05 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-13, 07:37 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-13, 08:08 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-13, 09:20 PM
RE: MyISAM vs InnoDB for MyBB? - by Hewret - 2016-12-13, 08:19 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-14, 04:12 PM
RE: MyISAM vs InnoDB for MyBB? - by dragonexpert - 2016-12-14, 10:08 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-15, 05:40 AM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2017-01-15, 02:55 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)