[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: unable to recover a mediawiki database
From:       Micah Stevens <micah () raincross-tech ! com>
Date:       2007-03-31 15:49:52
Message-ID: 460E8320.3030703 () raincross-tech ! com
[Download RAW message or body]

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
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]