[# 其他] Discuz数据库引擎 MyISAM 转InnoDB 记录

mysqldump -u 用户名 -p 数据库名 > /文件路径

ALTER TABLE pre_forum_post CHANGE position position int(8) unsigned NOT NULL;

ALTER TABLE pre_common_member_grouppm ADD INDEX gpmid(gpmid);

$_config['db']['common']['engine'] = 'innodb';

ALTER TABLE pre_ucenter_tags ENGINE=InnoDB;

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE Engine='MyISAM' AND TABLE_SCHEMA='数据库名' ;

<?php

include_once('./config/config_global.php');

$servername = $_config['db']['1']['dbhost'];

$username = $_config['db']['1']['dbuser'];

$password = $_config['db']['1']['dbpw'];

$dbname = $_config['db']['1']['dbname'];



$mysqli = mysqli_connect($servername, $username, $password, $dbname) ;



$dbname = '\''.$dbname.'\'';

$sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE Engine='MyISAM' AND TABLE_SCHEMA=$dbname";



//执行查询

$result = $mysqli->query($sql);

if($result === false){ //执行失败

    echo $mysqli->error;

    echo $mysqli->errno;

}

//输出结果

while($row = $result->fetch_assoc()) {

echo 'ALTER TABLE '.$row['TABLE_NAME'].' ENGINE=InnoDB;' .'<br>';



}



// 销毁变量

$servername = '';

$username = '';

$password = '';

$dbname = '';



?>