bosss Posted June 24, 2021 Share Posted June 24, 2021 Maybe someone know how make conversion database tables (easiest way) from MYisam to InnoDB ? Quote Link to comment Share on other sites More sharing options...
Legionaire Posted June 24, 2021 Share Posted June 24, 2021 In the next arcade release that should be done for you (crosses fingers) Quote Link to comment Share on other sites More sharing options...
bosss Posted June 24, 2021 Author Share Posted June 24, 2021 50 minutes ago, Legionaire said: In the next arcade release that should be done for you (crosses fingers) You mean only arcade database tables or all tables ? Quote Link to comment Share on other sites More sharing options...
Legionaire Posted June 24, 2021 Share Posted June 24, 2021 if you are talking about your IPS installation, it would be only the arcade tables as they are the only ones that are giving the error about innoDB Quote Link to comment Share on other sites More sharing options...
bosss Posted June 24, 2021 Author Share Posted June 24, 2021 1 hour ago, Legionaire said: if you are talking about your IPS installation, it would be only the arcade tables as they are the only ones that are giving the error about innoDB My all tables are MYISAM no one are InnoDB - and yes got notice in my admin cp about to change to InnoDB Quote Link to comment Share on other sites More sharing options...
Legionaire Posted June 24, 2021 Share Posted June 24, 2021 Have you upgraded to 4.6.x already ? Quote Link to comment Share on other sites More sharing options...
bosss Posted June 24, 2021 Author Share Posted June 24, 2021 34 minutes ago, Legionaire said: Have you upgraded to 4.6.x already ? Yes - upgraded to 4.6.2 and all my tables in database is MYisam Quote Link to comment Share on other sites More sharing options...
Legionaire Posted June 24, 2021 Share Posted June 24, 2021 That's odd, when I upgraded, all the tables for the IPS software were innoDB tables and all I had to do was change the ones for the arcade Quote Link to comment Share on other sites More sharing options...
bosss Posted June 25, 2021 Author Share Posted June 25, 2021 13 hours ago, Legionaire said: That's odd, when I upgraded, all the tables for the IPS software were innoDB tables and all I had to do was change the ones for the arcade Will try manually convert to InnoDB! Quote Link to comment Share on other sites More sharing options...
bosss Posted June 25, 2021 Author Share Posted June 25, 2021 Fixed Quote Link to comment Share on other sites More sharing options...
Windwalker Posted July 6, 2021 Share Posted July 6, 2021 Oh, that was LOADS of fun. I tried figuring out how to use the SQL interface for an easy way and gave up. When I went to 4.6 it didn't upgrade any of the IPB tables, or maybe a few. So I went through one by one, a few at the time, and changed them to InnoDB. I notice it never shows any over head anymore, and I'm not having lags like I used to in the forum. It's been a week or so, so hopefully all will be well. Quote Link to comment Share on other sites More sharing options...
Legionaire Posted July 6, 2021 Share Posted July 6, 2021 Yea, unfortunately for those who's tables do not convert, you have to manually change each table Quote Link to comment Share on other sites More sharing options...
Legionaire Posted July 6, 2021 Share Posted July 6, 2021 When we built the upcoming release for the arcade we went in and changed all of that so it should update the arcade tables on install Quote Link to comment Share on other sites More sharing options...
bosss Posted July 6, 2021 Author Share Posted July 6, 2021 If someone need check to see if any myISAM tables exist. ( Run this query). Replace ‘database’ with your database name. SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'database' and ENGINE = 'myISAM' Quote Link to comment Share on other sites More sharing options...
Sousbi Posted July 8, 2021 Share Posted July 8, 2021 Bonjour, Voici comment je procède donc ci cela peut être utile. Commande SQL: Here is how I do it so it can be useful. SQL command: SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' ENGINE=InnoDB;') FROM information_schema.tables WHERE 1=1 AND engine = 'MyISAM' AND table_schema NOT IN ('information_schema', 'mysql', 'performance_schema'); Résultat: Copier le résultat et coller le dans SQL Copy the result and paste it in SQL Et voila toutes les tables trouvé au format MyISAM sont converti vers InnoDB And here are all the tables found in MyISAM format are converted to InnoDB Quote Link to comment Share on other sites More sharing options...
Legionaire Posted July 8, 2021 Share Posted July 8, 2021 Thanks Sousbi, appreciate the info 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.