News:

Wondering if this will always be free?  See why free is better.

Main Menu

Convert MariaDB tables to InnoDB

Started by spiros, October 12, 2016, 02:11:46 PM

Previous topic - Next topic

spiros

I tried this:

ALTER TABLE smf_log_errors
TYPE=InnoDB;

And I got:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=InnoDB' at line 2

What should I be doing?

Edit: I got it:

ALTER TABLE smf_log_errors ENGINE=InnoDB

vbgamer45

Yeah type= is goine in new versions of mysql
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Advertisement: