Re: q re transferring mysql db from redhat to debian

[Jeremy Zawodny <Jeremy@Zawodny.com>]

On Jul 26, 2004, at 7:56 PM, Brian Nelson wrote:

> Jeremy Zawodny <Jeremy@Zawodny.com> writes:
>
> > On Jul 26, 2004, at 6:21 PM, Shannon R. wrote:
> >
> > > hello list!
> > >
> > >
> > > i'll be moving from a RedHat server to a Debian server very soon.
> > > despite the different linux distributions, is it ok to transfer my
> > > entire
> > > mysql database by just copying everything in /var/lib/mysql of the
> > > RedHat
> > >  system to the Debian system?
> >
> > Assuming the directory structures are similar and you're using only
> > MyISAM tables, yes.  With InnoDB, you'd have to deal with the logs as
> > well.
>
> Surely using mysqldump(1) would be safer, especially if the MySQL
> versions are different.

Well, either way you're copying a bunch of bits from server A to server 
B.  I'm not sure how the actual data format matters.  Copying the raw 
data will be more efficient.

Jeremy