About Databases and other wondrous things (MariaDB)

[puertoblack2003]

Originally Posted by AusPhotography

InnoDB -> XtraDB is default for MariaDB > 10.0.8
Aria conversion is easy using phpMyAdmin, just change the table type
or
ALTER TABLE xxxx ENGINE=Aria;

--------------- Added [DATE]1424132633[/DATE] at [TIME]1424132633[/TIME] ---------------

Tracker http://tracker.vbulletin.com/browse/VBIV-16069

I'm using 5.5.40 version. do i apply same setting conversion?

[squidsk]

The sql syntax should be the same and as long as the destination engine for the query is installed and enabled (which it should be if that 5.5.40 is mariadb 5.5.40) then yes that sql query should do the trick.

[AusPhotography]

MariaDB did not implement MySQL 5.6 completely due to instability/quality issues.
Hence they started a new numbering system 10.x.x.x

[AusPhotography]

Originally Posted by squidsk

Have you reported that on the bug tracker? It's a small enough bug that it should be able to be fixed.

It's in 4.2.3beta 4

[markoroots]

Guys after done this, how to fix the right syntax of the sql queries to the database??

[Dave]

You don't have to. MariaDB is based on MySQL and therefore the syntax is exactly the same.

[Paul M]

As Dave says, there should not be any syntax to change, its a like for like replacement.