anhbeu Member Apr 23, 2012 #1 Hi sorry my english not good When i install XF i forgot check Mysql.cnf config. Now all Table is Myisam it hard for me when reinstall because i made change alot of config ..... plz help me convert table to Innodb with query. thank you
Hi sorry my english not good When i install XF i forgot check Mysql.cnf config. Now all Table is Myisam it hard for me when reinstall because i made change alot of config ..... plz help me convert table to Innodb with query. thank you
anhbeu Member Apr 23, 2012 #3 Rob said: Personally, I would reinstall Click to expand... thank, but i hard when i reconfig all setting Upvote 0 Downvote
Rob said: Personally, I would reinstall Click to expand... thank, but i hard when i reconfig all setting
Rob Well-known member Apr 23, 2012 #4 Well, you can use this against each table:- Code: ALTER TABLE table_name ENGINE = InnoDB; Upvote 0 Downvote
anhbeu Member Apr 23, 2012 #5 Rob said: Well, you can use this against each table:- Code: ALTER TABLE table_name ENGINE = InnoDB; Click to expand... thank. it resolved Upvote 0 Downvote
Rob said: Well, you can use this against each table:- Code: ALTER TABLE table_name ENGINE = InnoDB; Click to expand... thank. it resolved
H HWS Well-known member Apr 26, 2012 #6 This may help: http://dev.mysql.com/doc/refman/5.5/en/converting-tables-to-innodb.html A simple ALTER TABLE may run into troubles with a large database size. Upvote 0 Downvote
This may help: http://dev.mysql.com/doc/refman/5.5/en/converting-tables-to-innodb.html A simple ALTER TABLE may run into troubles with a large database size.
