Install MariaDB Archive Program
I have installed MariaDB on my Debian but the Archive Engine is missing. Is there a way to install the Archive Engine?
I don't have a ha_archive file in / usr / lib / mysql / plugin directory
+3
source to share
2 answers
Try installing the plugin using the SQL wrapper.
MariaDB> INSTALL PLUGIN SONAME archive 'ha_archive.so';
Show plugins
MariaDB> show engines \ G
EDIT:
I have installed mariadb-10.x on ubuntu and it ARCHIVE
is enabled by default.
MariaDB> show engines \ G
*************************** 7. row ***************************
Engine: ARCHIVE
Support: YES
Comment: Archive storage engine
Transactions: NO
XA: NO
Savepoints: NO
+5
source to share
I fixed this by entering the following command in MariaDB, logged in as root user -
MariaDB [(none)]> INSTALL SONAME 'ha_archive';
Query OK, 0 rows affected (0.33 sec)
Check if it is installed -
MariaDB [(none)]> SHOW ENGINES;
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
| MRG_MyISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |
| SEQUENCE | YES | Generated tables filled with sequential values | YES | NO | YES |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
| InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES | YES | YES |
| Aria | YES | Crash-safe tables with MyISAM heritage | NO | NO | NO |
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)
0
source to share