From: Rick James
Date: November 29 2010 7:25pm
Subject: Re: Saving an old database from a dead server
List-Archive: http://lists.mysql.com/replication/2009
Message-Id: <4CF3FE19.5030300@yahoo-inc.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Please provide some details...
Did you copy only the database subdirectory?  Or the entire tree (as I 
suggested)?
Did your cp include ibdata1?
What was the setting of innodb_file_per_table?
Which 5.0.xx ?

(I often get questions about backuping up InnoDB tables via cp; I would 
like to know if you have found a different way that is successful.)

On 11/29/10 11:15 AM, Magnus Ekhall wrote:
> I'm using InnoDB.
>
> Good news: I think I just managed to get a dump from the database!
>
> I installed an old version of Ubuntu in a VirtualBox and copied the
> database files to that box. mysqldump seemed to work just fine then!
>
> :)
>
> Thanks all for the many ideas and for all the help.
>
> Regards,
> Magnus
>
> mån 2010-11-29 klockan 16:54 -0200 skrev Wagner Bianchi:
>> As Rick said, having a cp of files, in the case that you are using InnoDB,
>> it isn't enough. Other problem is regarding to the compatibility model of
>> InnoDB tablespace. The logical structure of this file have been changed
>> since MySQL 5.0.
>>
>> So, are you using InnoDB or MyISAM in old database?
>>
>> Best regards.
>> --
>> WB
>>
>> 2010/11/29 Rick James<rjames@stripped>
>>
>>> Put all of
>>>
>>> /var/lib/mysql
>>>
>>> on a fresh machine; not just the database directory.  Then backup the
>>> desired table(s).
>>>
>>> If you are using InnoDB , the directory you chose won't suffice.  If it is
>>> MyISAM, it should have worked.
>>>
>>>
>>> On 11/28/10 12:17 PM, Magnus Ekhall 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
>>>>
>>>>
>>>>
>>>>
>>> --
>>> Rick James - MySQL Geek
>>>
>>>
>>> --
>>> MySQL Replication Mailing List
>>> For list archives: http://lists.mysql.com/replication
>>> To unsubscribe:
>>> http://lists.mysql.com/replication?unsub=wagnerbianchijr@stripped
>>>
>>>
>

-- 
Rick James - MySQL Geek