[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: q re transferring mysql db from redhat to debian

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.

You win again, gravity!

Reply to: