The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB xtradb installation problem

HI all!

I'm install mariadb from freebsd ports databases/mariadb

with options

root@mx1/var/db/ports/mariadb> cat options 
# This file is auto-generated by 'make config'.
# No user-servicable parts inside!
# Options for mariadb-5.2.5
_OPTIONS_READ=mariadb-5.2.5
WITH_ARIADB=true
WITH_ARCHIVE=true
WITH_BLACKHOLE=true
WITHOUT_FEDERATED=true
WITH_FEDERATEDX=true
WITHOUT_INNODB=true
WITH_XTRADB=true
WITHOUT_OQGRAPH=true
WITHOUT_PBXT=true
WITHOUT_PARTITION=true
WITH_SPHINX=true
WITHOUT_NDB=true
WITHOUT_EXAMPLES=true
WITHOUT_PORTEVENT=true
WITHOUT_SSL=true
WITHOUT_OPENSSL=true

after making mysql_upgrade a have many errors like

nikonistwp.g2_WatermarkImage
Error    : Unknown table engine 'InnoDB'
error    : Corrupt
nikonistwp.g2_WebDavLockMap
Error    : Unknown table engine 'InnoDB'
error    : Corrupt
postfix.vacation
Error    : Unknown table engine 'InnoDB'
error    : Corrupt
postfix.vacation_notification
Error    : Unknown table engine 'InnoDB'

and in log file error like

110602 11:45:09 [ERROR] /usr/local/libexec/mysqld: unknown variable 'innodb_data_home_dir=/usr/local/var/db/mysql/'
110602 12:40:06 [ERROR] /usr/local/libexec/mysqld: unknown variable 'innodb_data_home_dir=/usr/local/var/db/mysql/'
110602 12:57:04 [ERROR] /usr/local/libexec/mysqld: unknown variable 'innodb_data_home_dir=/usr/local/var/db/mysql/'
110602 14:02:11 [ERROR] /usr/local/libexec/mysqld: unknown variable 'innodb_data_home_dir=/usr/local/var/db/mysql/'

XTRADB d't work :( please help solve this problemm.

PS now i comment this in my.cnf

##innodb_data_home_dir = /usr/local/var/db/mysql/
##innodb_data_file_path = ibdata1:10M:autoextend
##innodb_log_group_home_dir = /usr/local/var/db/mysql/
#innodb_log_arch_dir = /usr/local/var/db/mysql/
##innodb_buffer_pool_size = 256M
##innodb_additional_mem_pool_size = 20M
##innodb_log_file_size = 64M
##innodb_log_buffer_size = 8M
##innodb_flush_log_at_trx_commit = 2
##innodb_lock_wait_timeout = 50

Answer Answered by Geoffroy Desvernay in this comment.

You may have a look at current pkg-message of the port (/usr/ports/databases/mariadb/pkg-message) Where I documented this problem: you just have to load xtradb plugin from /var/db/mysql/my.cnf:

[mysqld] plugin-load=ha_xtradb.so

nb: the port will be split in -server, -client and -script in the next days

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.