SEO

Hello

I am using MySql to store two MediaWiki databases named dftdb and framesdb
I am using MySql 4.1.20
I am using MediaWiki 1.9.3
I am using Scientific Linux 4.4

Each week I backup the directory /var/lib/mysql
On Wednesday I lost the /var partition, the mysql version,
the apache and php5, MediaWiki was the only one to stay alive.


I reinstalled the same versions of mysql, apache, php5 that were
running before the crash.

I copy the the saved /var/lib/mysql directory

A third old wiki running under Mediawiki 1.3 was correctly recovered
but, the new two new Wikis running under MediaWiki 1.9.3 I give the following
message :


MediaWiki internal error.

Original exception: exception 'DBQueryError' with message 'A database error has
occurred
Query: SELECT value,exptime FROM `dft_objectcache` WHERE
keyname='dftdb-dft_:messages-hash'
Function: MediaWikiBagOStuff::_doquery
Error: 1016 Can't open file: 'dft_objectcache.ibd' (errno: 1) (localhost)
' in /home/dft/public_html/mediawiki/includes/Database.php:708


under phpMyAdmin these databases have no Type defined for the 33 tables
excepted 3 which have MyiSAM type.
The Collation column give "in use".

If somebody could tell me what happenned ?
How a running database could become unreadable after reinstalling Mediawiki.
Is it possible that this were connected with the InnoDb type which is
the default used by phpMyAdmin at database creation ?

Thanks

Francois Colonna

Did you shut down the database when you backed up the data folder, or
was it running? Sounds like file corruption to me which can occur from
grabbing those data files while they're being used by the database.

If the table type is innoDB, I'm not much use, but if they're MyISAM,
the command line rebuilding tools are where I'd start.

-Micah

On 03/31/2007 06:09 AM, Francois Colonna wrote:
> Hello
>
> I am using MySql to store two MediaWiki databases named dftdb and
> framesdb
> I am using MySql 4.1.20
> I am using MediaWiki 1.9.3
> I am using Scientific Linux 4.4
>
> Each week I backup the directory /var/lib/mysql
> On Wednesday I lost the /var partition, the mysql version,
> the apache and php5, MediaWiki was the only one to stay alive.
>
>
> I reinstalled the same versions of mysql, apache, php5 that were
> running before the crash.
>
> I copy the the saved /var/lib/mysql directory
>
> A third old wiki running under Mediawiki 1.3 was correctly recovered
> but, the new two new Wikis running under MediaWiki 1.9.3 I give the
> following message :
>
>
> MediaWiki internal error.
>
> Original exception: exception 'DBQueryError' with message 'A database
> error has occurred
> Query: SELECT value,exptime FROM `dft_objectcache` WHERE
> keyname='dftdb-dft_:messages-hash'
> Function: MediaWikiBagOStuff::_doquery
> Error: 1016 Can't open file: 'dft_objectcache.ibd' (errno: 1) (localhost)
> ' in /home/dft/public_html/mediawiki/includes/Database.php:708
>
>
> under phpMyAdmin these databases have no Type defined for the 33 tables
> excepted 3 which have MyiSAM type.
> The Collation column give "in use".
>
> If somebody could tell me what happenned ?
> How a running database could become unreadable after reinstalling
> Mediawiki.
> Is it possible that this were connected with the InnoDb type which is
> the default used by phpMyAdmin at database creation ?
>
> Thanks
>
> Francois Colonna
>