Hi ed, all!
ed wrote:
I have recently noticed I can not access a PHP application's data files,
and the errors I am getting seem to show that a recent update of the
distro (mandriva) no longer supports innodb, and this may be a reason
Which version were you using before, and which one are you using now?
(if this is not some sort of catchall error). I would like to know how
to add innodb plugin back into my mysql, or to convert the data to a
usable format. I would be pleased with a pointer to the correct rtfd
location.
From your output, I'd say they removed or unconfigured some parts in the
source before creating binaries.
(If your previous version was taken from the same source, they did an
incompatible change IMNSHO, and I hope they did give a thorough warning.
If not, you should raise a complaint.)
I guess wordwrap is going to mess this up;
mysql 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 |
| MEMORY | YES | Hash based, stored in memory, useful for
temporary tables | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with
great performance| NO | NO | NO |
++-+---+--+--++
show plugins;
++++-+-+
| Name | Status | Type | Library | License |
++++-+-+
| binlog | ACTIVE | STORAGE ENGINE | NULL| GPL|
| partition | ACTIVE | STORAGE ENGINE | NULL| GPL |
| CSV| ACTIVE | STORAGE ENGINE | NULL| GPL|
| MEMORY | ACTIVE | STORAGE ENGINE|NULL |GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL| GPL|
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL| GPL |
This is what show engines and show plugins report in my test build
of post-5.1.57 (complete sources):
= ENGINES =
Engine Support Comment TransactionsXA Savepoints
ndbcluster NO Clustered, fault-tolerant tablesNULL
NULLNULL
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
CSV YES CSV storage engine NO NO NO
MEMORY YES Hash based, stored in memory, useful for temporary
tables NO NO NO
FEDERATED NO Federated MySQL storage engine NULLNULL
NULL
ARCHIVE YES Archive storage engine NO NO NO
InnoDB YES Supports transactions, row-level locking, and foreign
keys YES YES YES
MyISAM DEFAULT Default engine as of MySQL 3.23 with great performance
NO NO NO
= PLUGINS =
NameStatus TypeLibrary License
binlog ACTIVE STORAGE ENGINE NULLGPL
partition ACTIVE STORAGE ENGINE NULLGPL
ARCHIVE ACTIVE STORAGE ENGINE NULLGPL
BLACKHOLE ACTIVE STORAGE ENGINE NULLGPL
CSV ACTIVE STORAGE ENGINE NULLGPL
FEDERATED DISABLEDSTORAGE ENGINE NULLGPL
MEMORY ACTIVE STORAGE ENGINE NULLGPL
InnoDB ACTIVE STORAGE ENGINE NULLGPL
MRG_MYISAM ACTIVE STORAGE ENGINE NULLGPL
MyISAM ACTIVE STORAGE ENGINE NULLGPL
ndbcluster DISABLEDSTORAGE ENGINE NULLGPL
I don't think there is a way to add those missing parts back to your
current binaries.
If you have tables using the InnoDB engine, I see these approaches you
could take:
1) Go back to the version you used previously.
You have a full system backup, I trust ?
2) Build from source.
3) Use other binary packages, like those available directly from MySQL
(now: Oracle).
[[...]]
HTH,
Joerg
--
Joerg Bruehe, MySQL Build Team, joerg.bru...@oracle.com
ORACLE Deutschland B.V. Co. KG, Komturstrasse 18a, D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org