Try:
mysqlcheck -vq --all-databases --auto-repair
On Nov 28, 2010, at 3:51 PM, Magnus Ekhall wrote:
> I tried running mysqlrepair (on a copy of the data), but it objects
> with:
>
> thedatabase.atable
> Error : Incorrect key file for table 'atable'; try to repair it
> error : Corrupt
>
> I guess I could try and install some old ubuntu release in a which has a
> 4.1-server in a VirtualBox and see if the same error occurs there...
>
> Regards,
> Magnus
>
>
> sön 2010-11-28 klockan 14:41 -0600 skrev Jeff Smelser:
>> if you have another copy, I would try to repair it.. I think it just needs
>> to redo the keys.
>>
>> On Sun, Nov 28, 2010 at 2:39 PM, Magnus Ekhall <koma@stripped>
> wrote:
>>
>>> Well, mysql seems to understand that the database should exist.
>>>
>>> But when I try to dump it, (or just do a select * from table;) i get
>>> error messages like:
>>>
>>> mysqldump: Got error: 1034: Incorrect key file for table 'atable'; try
>>> to repair it when using LOCK TABLES
>>>
>>> I assume (perhaps incorrectly) that these errors are beacause I'm trying
>>> to forcibly insert a 4.1 database into a 5.x server...
>>>
>>> But maybe not?
>>>
>>> Your answer gives me hope; that it should work the way I'm trying it
>>> now!
>>>
>>> Thanks a lot for answering!
>>>
>>> Regards,
>>> Magnus
>>>
>>>
>>> sön 2010-11-28 klockan 14:21 -0600 skrev Jeff Smelser:
>>>> Define "Did not work?"
>>>>
>>>> As long as the my.cnf are the same, and mysql was NOT running when you
>>>> copied the files. it should work.
>>>>
>>>> Unless the files are bad.
>>>>
>>>> On Sun, Nov 28, 2010 at 2:17 PM, Magnus Ekhall
> <koma@stripped>
>>> wrote:
>>>>
>>>>> Hello,
>>>>>
>>>>> I am trying to do a rather odd replication of a mysql database and
> need
>>>>> some hints.
>>>>>
>>>>> An old server of mine died horribly during a recent power outage.
>>>>> It had a mysql 4.1 server. The hardware has just given up, but I
> have
>>>>> managed to get all files from the harddrive.
>>>>>
>>>>> Since the server won't boot I cannot run mysqldump.
>>>>>
>>>>> I then tried just moving the database files
>>>>> from /var/lib/mysql/thedatabas onto a fresh install of mysql (in
> Ubuntu
>>>>> 10.10, so version 5.x), but that did not work.
>>>>>
>>>>> Can anyone suggest a way to get a dump of my database somehow?
>>>>>
>>>>> I'm going to set up a new server running a recent version of mysql,
> so
>>>>> the equivalent of mysqldump is ideal.
>>>>>
>>>>> Any ideas at all?
>>>>>
>>>>> Regards,
>>>>> Magnus
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> MySQL Replication Mailing List
>>>>> For list archives: http://lists.mysql.com/replication
>>>>> To unsubscribe:
>>>>> http://lists.mysql.com/replication?unsub=1
>>>>>
>>>>>
>>>
>>>
>>>
>>> --
>>> MySQL Replication Mailing List
>>> For list archives: http://lists.mysql.com/replication
>>> To unsubscribe:
>>> http://lists.mysql.com/replication?unsub=1
>>>
>>>
>
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: http://lists.mysql.com/replication?unsub=1
>
