Re: q re transferring mysql db from redhat to debian
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:
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
mysql database by just copying everything in /var/lib/mysql of the
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
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.