Can't covert innodb back to myisam

**gillaraz** · Wed 15 Jun '11, 8:58am

anyone ??

**punchbowl** · Wed 15 Jun '11, 9:05am

check you don't have 'skip-innodb' in your my.cnf/my.ini

also check your error logs for clues

**Zachery** · Wed 15 Jun '11, 10:08am

Have you tried going into each of those tables and changing them with phpmyadmin?

**gillaraz** · Wed 15 Jun '11, 12:01pm

Originally posted by Zachery

Have you tried going into each of those tables and changing them with phpmyadmin?

I tried but phpmyadmin show same result

MySQL said: Documentation
#1286 - Unknown table engine 'InnoDB'

and didn't do anything.

I tried to access to see structure of that table but can't as well. Also, in all table page, the table " contenttype" shows word "in use". I don't what does it mean.

**George L** · Wed 15 Jun '11, 1:53pm

gillaraz

I suspect you don't have innodb tables in usage ? As from the error it seems innodb is disabled and well if you had innodb tables, your vB forum wouldn't work.

But if you do, to convert back from innodb to myisam, take another read of http://vbtechsupport.com/675/ as you seem to have innodb storage engine disabled in mysql hence the unknown table engine error. You need to ensure innodb is enabled in my.cnf as per article.

To enable or disable InnoDB storage engine support you would have to make changes in /etc/my.cnf (in linux) or C:\my.ini (windows) and then restart MySQL server for changes to take affect.

To enable InnoDB support comment out the skip-innodb option

Code:

[mysqld]
#skip-innodb
default-storage-engine = MyISAM

Make sure InnoDB storage engine is supported in SSH2 telnet type:

mysqladmin -u mysqlusername -p var | grep have_innodb

Code:

| have_innodb                               | YES

to double check in ssh2 telnet type this command pretty long

mysql -u mysqlusername -p -e "SELECT CONCAT(table_schema,'.',table_name) AS 'Table Name', CONCAT(ROUND(table_rows,2),' Rows') AS 'Number of Rows',ENGINE AS 'Storage Engine',CONCAT(ROUND(data_length/(1024*1024),2),'MB') AS 'Data Size',CONCAT(ROUND(index_length/(1024*1024),2),'MB') AS 'Index Size' ,CONCAT(ROUND((data_length+index_length)/(1024*1024),2),'MB') AS'Total'FROM information_schema.TABLES WHERE table_schema LIKE 'databasename';"

where

mysqlusername = mysql username
databasename = database name

You’ll be prompted for your mysqlusername’s password. The out put would look like this.

Code:

+-----------------------------------------+----------------+----------------+-----------+------------+----------+
| Table Name                              | Number of Rows | Storage Engine | Data Size | Index Size | Total    |
+-----------------------------------------+----------------+----------------+-----------+------------+----------+
| vb413dbname.access                      | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB   |
| vb413dbname.adminhelp                   | 1744 Rows      | MyISAM         | 0.09MB    | 0.08MB     | 0.17MB   |
| vb413dbname.administrator               | 1 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB   |
| vb413dbname.adminlog                    | 23713 Rows     | MyISAM         | 1.30MB    | 0.31MB     | 1.61MB   |
| vb413dbname.adminmessage                | 4 Rows         | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB   |

and post output here

if ssh telnet client's scrollback buffer isn't large enough to show all tables use this command and copy and paste out of the table.txt file

mysql -u mysqlusername -p -e "SELECT CONCAT(table_schema,'.',table_name) AS 'Table Name', CONCAT(ROUND(table_rows,2),' Rows') AS 'Number of Rows',ENGINE AS 'Storage Engine',CONCAT(ROUND(data_length/(1024*1024),2),'MB') AS 'Data Size',CONCAT(ROUND(index_length/(1024*1024),2),'MB') AS 'Index Size' ,CONCAT(ROUND((data_length+index_length)/(1024*1024),2),'MB') AS'Total'FROM information_schema.TABLES WHERE table_schema LIKE 'databasename';" > table.txt

**gillaraz** · Wed 15 Jun '11, 9:35pm

Yes, I don't have innod enable and I can access only phpmyadmin. How can I use command like that in phpmyadmin? Do I have to use ssh2 telnet ?

**George L** · Thu 16 Jun '11, 12:04am

via phpmyadmin should be able to do it via

SELECT CONCAT(table_schema,'.',table_name) AS 'Table Name', CONCAT(ROUND(table_rows,2),' Rows') AS 'Number of Rows',ENGINE AS 'Storage Engine',CONCAT(ROUND(data_length/(1024*1024),2),'MB') AS 'Data Size',CONCAT(ROUND(index_length/(1024*1024),2),'MB') AS 'Index Size' ,CONCAT(ROUND((data_length+index_length)/(1024*1024),2),'MB') AS'Total'FROM information_schema.TABLES WHERE table_schema LIKE 'databasename';

just change databasename

**gillaraz** · Thu 16 Jun '11, 5:55am

Originally posted by eva2000

via phpmyadmin should be able to do it via

just change databasename

the result is very long and another command that save as .txt is not work. So, I have to export as sql

You can see here

('xxx.access', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.action', '18 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.ad', '5 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.adcriteria', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.adminhelp', '1747 Rows', 'MyISAM', '0.12MB', '0.09MB', '0.20MB'),
('xxx.administrator', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.adminlog', '3268 Rows', 'MyISAM', '0.17MB', '0.05MB', '0.23MB'),
('xxx.adminmessage', '3 Rows', 'MyISAM', '0.00MB', '0.01MB', '0.01MB'),
('xxx.adminutil', '3 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.album', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.albumupdate', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.announcement', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.announcementread', '7 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.apiclient', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.apilog', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.attachment', '1 Rows', 'MyISAM', '0.00MB', '0.01MB', '0.01MB'),
('xxx.attachmentcategory', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.attachmentcategoryuser', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.attachmentpermission', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.attachmenttype', '11 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.attachmentviews', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.avatar', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.bbcode', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.bbcode_video', '7 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.block', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blockconfig', '3 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.blocktype', '5 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog', '386 Rows', 'MyISAM', '0.04MB', '0.05MB', '0.09MB'),
('xxx.blog_attachmentlegacy', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_category', '6 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_categorypermission', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_categoryuser', '14 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_custom_block', '2 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_custom_block_parsed', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_deletionlog', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_editlog', '7 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_featured', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_groupmembership', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_grouppermission', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_hash', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_moderation', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_moderator', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_pinghistory', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_rate', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_read', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_relationship', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_search', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_searchresult', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_sitemapconf', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_subscribeentry', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_subscribeuser', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_summarystats', '109 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.blog_tachyentry', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_text', '415 Rows', 'MyISAM', '0.89MB', '0.91MB', '1.81MB'),
('xxx.blog_textparsed', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_trackback', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_trackbacklog', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_user', '23 Rows', 'MyISAM', '0.01MB', '0.00MB', '0.01MB'),
('xxx.blog_usercss', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_usercsscache', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_userread', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_userstats', '14 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_views', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.blog_visitor', '23 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.bookmarksite', '4 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.cache', '429 Rows', 'MyISAM', '0.44MB', '0.03MB', '0.47MB'),
('xxx.cacheevent', '278 Rows', 'MyISAM', '0.02MB', '0.02MB', '0.04MB'),
('xxx.calendar', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.calendarcustomfield', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.calendarmoderator', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.calendarpermission', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.cms_article', '11 Rows', 'MyISAM', '0.02MB', '0.00MB', '0.03MB'),
('xxx.cms_category', '9 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.cms_grid', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.cms_layout', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.cms_layoutwidget', '6 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.cms_navigation', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.cms_node', '18 Rows', 'MyISAM', '0.00MB', '0.01MB', '0.01MB'),
('xxx.cms_nodecategory', '11 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.cms_nodeconfig', '23 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.cms_nodeinfo', '18 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.cms_permissions', '10 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.cms_rate', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.cms_sectionorder', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.cms_widget', '8 Rows', 'MyISAM', '0.00MB', '0.01MB', '0.01MB'),
('xxx.cms_widgetconfig', '17 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.cms_widgettype', '22 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.contentpriority', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.contenttype', NULL, NULL, NULL, NULL, NULL),
('xxx.cpsession', '0 Rows', 'MEMORY', '16.00MB', '12.80MB', '28.80MB'),
('xxx.cron', '28 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.cronlog', '2890 Rows', 'MyISAM', '0.20MB', '0.04MB', '0.24MB'),
('xxx.customavatar', '95 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.customprofile', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.customprofilepic', '17 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.datastore', '38 Rows', 'MyISAM', '0.22MB', '0.00MB', '0.23MB'),
('xxx.dbquery', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.deletionlog', '7 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.discussion', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.discussionread', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.editlog', '102 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.event', '6 Rows', 'MyISAM', '0.01MB', '0.01MB', '0.02MB'),
('xxx.externalcache', '6 Rows', 'MyISAM', '1.27MB', '0.00MB', '1.27MB'),
('xxx.faq', '80 Rows', 'MyISAM', '0.00MB', '0.01MB', '0.01MB'),
('xxx.filedata', '1 Rows', 'MyISAM', '0.10MB', '0.01MB', '0.11MB'),
('xxx.forum', '24 Rows', 'MyISAM', '0.01MB', '0.00MB', '0.01MB'),
('xxx.forumpermission', '4 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.forumprefixset', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.forumread', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.glowhostspamomatic_log', '3807 Rows', 'MyISAM', '0.65MB', '0.00MB', '0.65MB'),
('xxx.glowhostspamomatic_remotecache', '774 Rows', 'MyISAM', '0.04MB', '0.00MB', '0.04MB'),
('xxx.groupmessage', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.groupmessage_hash', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.groupread', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.holiday', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.humanverify', '6 Rows', 'MyISAM', '0.05MB', '0.07MB', '0.11MB'),
('xxx.hvanswer', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.hvquestion', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.icon', '14 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.imagecategory', '3 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.imagecategorypermission', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.inactiveuserlog', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.indexqueue', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.infraction', '1 Rows', 'MyISAM', '0.00MB', '0.01MB', '0.01MB'),
('xxx.infractionban', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.infractiongroup', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.infractionlevel', '4 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.language', '1 Rows', 'MyISAM', '0.66MB', '0.00MB', '0.66MB'),
('xxx.mailqueue', '0 Rows', 'MyISAM', '0.18MB', '0.00MB', '0.19MB'),
('xxx.moderation', '3 Rows', 'MyISAM', '0.00MB', '0.01MB', '0.01MB'),
('xxx.moderator', '2 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.moderatorlog', '633 Rows', 'MyISAM', '0.05MB', '0.04MB', '0.09MB'),
('xxx.notice', '3 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.noticecriteria', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.noticedismissed', '7 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.package', '4 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.passwordhistory', '1211 Rows', 'MyISAM', '0.05MB', '0.01MB', '0.07MB'),
('xxx.paymentapi', '7 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.paymentinfo', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.paymenttransaction', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.phrase', '16086 Rows', 'MyISAM', '3.92MB', '1.60MB', '5.52MB'),
('xxx.phrasetype', '77 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.picturecomment', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.picturecomment_hash', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.picturelegacy', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.plugin', '170 Rows', 'MyISAM', '0.16MB', '0.01MB', '0.17MB'),
('xxx.pm', '558 Rows', 'MyISAM', '0.01MB', '0.02MB', '0.04MB'),
('xxx.pmreceipt', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.pmtext', '546 Rows', 'MyISAM', '0.19MB', '0.02MB', '0.21MB'),
('xxx.pmthrottle', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.podcast', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.podcastitem', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.poll', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.pollvote', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.post', '8304 Rows', 'MyISAM', '3.69MB', '0.78MB', '4.48MB'),
('xxx.postedithistory', '232 Rows', 'MyISAM', '0.21MB', '0.01MB', '0.22MB'),
('xxx.posthash', '4 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.postindex', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.postlog', '179 Rows', 'MyISAM', '0.03MB', '0.02MB', '0.05MB'),
('xxx.postparsed', '1397 Rows', 'MyISAM', '0.64MB', '0.05MB', '0.69MB'),
('xxx.prefix', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.prefixpermission', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.prefixset', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.product', '19 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.productcode', '26 Rows', 'MyISAM', '0.09MB', '0.00MB', '0.10MB'),
('xxx.productdependency', '12 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.profileblockprivacy', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.profilefield', '5 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.profilefieldcategory', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.profilevisitor', '80 Rows', 'MyISAM', '0.00MB', '0.01MB', '0.01MB'),
('xxx.ranks', '2 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.rbs_banners', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.rbs_hits', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.reminder', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.reputation', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.reputationlevel', '15 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.route', '5 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.rssfeed', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.rsslog', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.searchcore', '8789 Rows', 'MyISAM', '0.47MB', '0.93MB', '1.40MB'),
('xxx.searchcore_text', '8789 Rows', 'MyISAM', '4.29MB', '4.34MB', '8.63MB'),
('xxx.searchgroup', '1374 Rows', 'MyISAM', '0.05MB', '0.10MB', '0.15MB'),
('xxx.searchgroup_text', '1374 Rows', 'MyISAM', '0.07MB', '0.10MB', '0.17MB'),
('xxx.searchlog', '42 Rows', 'MyISAM', '3.41MB', '0.12MB', '3.52MB'),
('xxx.seoqueries_data', '1910 Rows', 'MyISAM', '0.06MB', '0.06MB', '0.12MB'),
('xxx.seoqueries_filtered_terms', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.seoqueries_terms', '1843 Rows', 'MyISAM', '0.07MB', '0.03MB', '0.10MB'),
('xxx.seoqueries_terms_stats', '11 Rows', 'MyISAM', '0.00MB', '0.01MB', '0.01MB'),
('xxx.session', '31 Rows', 'MEMORY', '16.00MB', '5.32MB', '21.32MB'),
('xxx.setting', '792 Rows', 'MyISAM', '0.12MB', '0.03MB', '0.15MB'),
('xxx.settinggroup', '75 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.sigparsed', '67 Rows', 'MyISAM', '0.02MB', '0.00MB', '0.02MB'),
('xxx.sigpic', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.skimlinks', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.smilie', '11 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.socialgroup', '1 Rows', 'MyISAM', '0.00MB', '0.01MB', '0.01MB'),
('xxx.socialgroupcategory', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.socialgroupicon', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.socialgroupmember', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.spamlog', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.stats', '495 Rows', 'MyISAM', '0.01MB', '0.01MB', '0.01MB'),
('xxx.strikes', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.style', '5 Rows', 'MyISAM', '0.66MB', '0.00MB', '0.66MB'),
('xxx.stylevar', '924 Rows', 'MyISAM', '0.11MB', '0.03MB', '0.14MB'),
('xxx.stylevardfn', '576 Rows', 'MyISAM', '0.03MB', '0.03MB', '0.06MB'),
('xxx.subscribediscussion', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.subscribeevent', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.subscribeforum', '1 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.subscribegroup', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.subscribethread', '30 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.subscription', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.subscriptionlog', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.subscriptionpermission', '2 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.tachyforumcounter', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.tachyforumpost', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.tachythreadcounter', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.tachythreadpost', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.tag', '199 Rows', 'MyISAM', '0.00MB', '0.01MB', '0.02MB'),
('xxx.tagcontent', '360 Rows', 'MyISAM', '0.01MB', '0.03MB', '0.04MB'),
('xxx.tagsearch', '575 Rows', 'MyISAM', '0.01MB', '0.02MB', '0.02MB'),
('xxx.template', '2095 Rows', 'MyISAM', '12.23MB', '0.11MB', '12.34MB'),
('xxx.templatehistory', '13 Rows', 'MyISAM', '0.10MB', '0.00MB', '0.10MB'),
('xxx.templatemerge', '14 Rows', 'MyISAM', '0.15MB', '0.00MB', '0.15MB'),
('xxx.thread', '918 Rows', 'MyISAM', '0.58MB', '0.18MB', '0.76MB'),
('xxx.threadrate', '37 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.threadread', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.threadredirect', '3 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.threadviews', '55 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.upgradelog', '87 Rows', 'MyISAM', '0.01MB', '0.00MB', '0.01MB'),
('xxx.user', '777 Rows', 'MyISAM', '0.17MB', '0.11MB', '0.29MB'),
('xxx.useractivation', '4 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.userban', '46 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.userchangelog', '905 Rows', 'MyISAM', '0.06MB', '0.12MB', '0.18MB'),
('xxx.usercss', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.usercsscache', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.userfield', '1208 Rows', 'MyISAM', '0.05MB', '0.01MB', '0.06MB'),
('xxx.usergroup', '10 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.usergroupleader', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.usergrouprequest', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.userlist', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.usernote', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.userpromotion', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.usertextfield', '1208 Rows', 'MyISAM', '0.07MB', '0.02MB', '0.09MB'),
('xxx.usertitle', '6 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.vblinklist_category', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.vblinklist_comment', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.vblinklist_entry', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.vblinklist_entryrate', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB'),
('xxx.visitormessage', '21 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.01MB'),
('xxx.visitormessage_hash', '0 Rows', 'MyISAM', '0.00MB', '0.00MB', '0.00MB');

**Zachery** · Thu 16 Jun '11, 9:50am

You dont have any innodb tables.

**George L** · Thu 16 Jun '11, 1:15pm

Yeah from that output you don't have any innodb tables hence the error message. You probably had innodb storage engine disabled when you installed/upgraded to vB4, so all tables are myisam and memory based.

**gillaraz** · Thu 16 Jun '11, 9:58pm

Originally posted by eva2000

Yeah from that output you don't have any innodb tables hence the error message. You probably had innodb storage engine disabled when you installed/upgraded to vB4, so all tables are myisam and memory based.

oh dear, what should I do ? My member can't even access to setting page

It always show this error.

Database error in vBulletin 4.1.3:

Invalid SQL:

SELECT contenttype.contenttypeid AS itemid

FROM contenttype AS contenttype
INNER JOIN package AS package
ON package.packageid = contenttype.packageid LEFT JOIN product AS product
ON product.productid = package.productid
WHERE
1 = 1 AND (product.active = '1' OR package.productid = 'vbulletin') AND contenttype.canattach = '1';

MySQL Error : Unknown table engine 'InnoDB'

**George L** · Fri 17 Jun '11, 4:27am

hmmm does look like contenttype table could of been converted to innodb or something happened as output you posted shows all fields as NULL

Code:

('xxx.contenttype', NULL, NULL, NULL, NULL, NULL),

if you have ssh2 telnet access can you post output from these commands

ls -alh /var/lib/mysql | grep contenttype

and from

mysqladmin -u mysqlusername -p var > info.txt

copy and paste output in the info.txt file

You may need to edit /etc/my.cnf and remove skip-innodb and restart mysql to enable innodb temporarily then run

alter table contenttype engine=MyISAM;

then disable innodb again by re-adding skip-innodb and restart mysql again

of course a full backup via mysqldump to sql BEFORE you convert tables.

**gillaraz** · Fri 17 Jun '11, 7:46am

Originally posted by eva2000

hmmm does look like contenttype table could of been converted to innodb or something happened as output you posted shows all fields as NULL

Code:

('xxx.contenttype', NULL, NULL, NULL, NULL, NULL),

if you have ssh2 telnet access can you post output from these commands

ls -alh /var/lib/mysql | grep contenttype

and from

mysqladmin -u mysqlusername -p var > info.txt

copy and paste output in the info.txt file

You may need to edit /etc/my.cnf and remove skip-innodb and restart mysql to enable innodb temporarily then run

alter table contenttype engine=MyISAM;

then disable innodb again by re-adding skip-innodb and restart mysql again

of course a full backup via mysqldump to sql BEFORE you convert tables.

Bad news for me , I haven't get ssh2 telnet acces

. I can just access only phpmyadmin.

**gillaraz** · Sat 18 Jun '11, 9:12am

hmmmm

vBulletin 4 End of Life

Can't covert innodb back to myisam

[Forum] Can't covert innodb back to myisam

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Related Topics