I upgraded my MySQL installation with MariaDB from obs://build.opensuse.org/server:database . InnoDB should be compiled as an internal part of the server, but all my InnoDB tables went corrupted.
zypper info mariadb
Loading repository data...
Reading installed packages...
Information for package mariadb:
Repository: @System
Name: mariadb
Version: 5.1.50-31.2
Arch: i586
Vendor: obs://build.opensuse.org/server:database
Installed: Yes
Status: up-to-date
Installed Size: 27.0 MiB
Summary: A True Multiuser, Multithreaded SQL Database Server
Description:
MariaDB is a backward compatible, drop-in replacement branch of the MySQL
Database Server. It includes all major open source storage engines, including
the Maria storage engine.
MariaDB (none)]> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| EXAMPLE | YES | Example storage engine | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| ndbcluster | NO | Clustered, fault-tolerant tables | NULL | NULL | NULL |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| FEDERATED | YES | Federated MySQL storage engine | NO | NO | NO |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)
show table status\G
*************************** 1. row ***************************
Name: log
Engine: NULL
Version: NULL
Row_format: NULL
Rows: NULL
Avg_row_length: NULL
Data_length: NULL
Max_data_length: NULL
Index_length: NULL
Data_free: NULL
Auto_increment: NULL
Create_time: NULL
Update_time: NULL
Check_time: NULL
Collation: NULL
Checksum: NULL
Create_options: NULL
Comment: Unknown table engine 'InnoDB'
Have I missed something and what can I do to fix it?