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: