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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.