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
Comments
Comments loading...
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.