Jump to content

Database conversion


bosss

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.

 

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

 

Link to comment
Share on other sites

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:

2.thumb.png.3b73c11d210a956c989cd4caa2adfcec.png

 

Copier le résultat et coller le dans SQL

 

Copy the result and paste it in SQL

 

3.thumb.png.2ba1e8f08d615d2cee5b9f9e4a4980e4.png

 

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

 

4.thumb.png.a019ecff26f3d4985fd8763131c18486.png

 

 

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.

Guest
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.

×
  • Create New...