What I said OS match meant what type of OS. Since you use Ubuntu on both old and new,
that's fine. But MySQL version is the matter. The 5.1 doesn't read data files came from
4.*. You have to dump data files from old version then reload to new version database.
--- On Sun, 11/28/10, Mihail Manolov <mmanolov@stripped> wrote:
> From: Mihail Manolov <mmanolov@stripped>
> Subject: Re: Saving an old database from a dead server
> To: "Magnus Ekhall" <koma@stripped>
> Cc: a.smith@stripped, database100@stripped, replication@stripped
> Date: Sunday, November 28, 2010, 5:09 PM
> The platform doesn't matter unless
> you have float type columns. I've migrated from 32bit to
> 64bit OS w/o any issues just by repairing the tables (both
> MyISAM and InnoDB.)
> Magnus, it's ok if you see the error, What matters is that
> at the end of the script will attempt to repair them. In
> case if repair fails, try to run the mysqlcheck command
> without -q, for example:
> myssqlcheck -v --all-databases --auto-repair
> On Nov 28, 2010, at 5:57 PM, a.smith@stripped
> > Hi,
> > more important than the version of Ubuntu is the
> architecture, ie amd64, ia64, x86 etc...
> > thanks Andy.
> > Quoting Magnus Ekhall <koma@stripped>:
> >> Lisa,
> >> Both the new and the old server are running Linux.
> Old: Ubuntu 5.10 with
> >> mysql 4.1 New: Ubuntu 10.10 with mysql 5.1
> >> I'm going to try to install Ubuntu 5.1 (or
> something similar) tomorrow.
> >> Thanks.
> >> Regards,
> >> Magnus
> > --
> > MySQL Replication Mailing List
> > For list archives: http://lists.mysql.com/replication
> > To unsubscribe: http://lists.mysql.com/replication?unsub=1