Maybe someone know how make conversion database tables (easiest way) from MYisam to InnoDB ?

In the next arcade release that should be done for you (crosses fingers)

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 ?

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

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

Have you upgraded to 4.6.x already ?

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

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

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!

Fixed

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.

Yea, unfortunately for those who's tables do not convert, you have to manually change each table

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

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'

 

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

 

 

 

Thanks Sousbi, appreciate the info