Jump to content

Database conversion


Recommended Posts

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

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
Share on other sites

If someone need check to see if any myISAM tables exist. ( Run this query). Replace ‘database’ with your database name.


FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'database' and ENGINE = 'myISAM'


Link to comment
Share on other sites


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
    AND engine = 'MyISAM'
    AND table_schema NOT IN ('information_schema', 'mysql', 'performance_schema');





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





Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...