vb.org Archive - About Databases and other wondrous things (MariaDB)

Page 2 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - About Databases and other wondrous things (MariaDB) (https://vborg.vbsupport.ru/showthread.php?t=317249)

puertoblack2003

02-17-2015 04:02 AM

Quote:

Originally Posted by AusPhotography (Post 2537716)

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

02-17-2015 03:04 PM

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

02-18-2015 07:59 AM

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

02-25-2015 01:59 AM

Quote:

Originally Posted by squidsk (Post 2537672)

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

04-27-2016 02:50 PM

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

Dave	04-27-2016 05:01 PM

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

Paul M

04-27-2016 05:08 PM

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

All times are GMT. The time now is 11:06 PM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01065 seconds Memory Usage 1,727KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: