Am 13.09.2016 um 12:09 schrieb Johan De Meersman:
----- Original Message -----
From: "Reindl Harald" <h.rei...@thelounge.net>
Subject: Re: MySQL Platform Migration
why shouldn't it when the identical software is running?
it's just a bunch of files used by mysql
Little/big endianness, for one, although I seem to recall, and your later mail
confirms, that that is not an issue for MySQL datafiles - and Mac has gone
Intel years ago anyway.
we discussed this multiple times here
There's no issue in this case; but it's not always as simple as 'same software,
same binary files'.
that's why you try things out - takes not longer than write 3 mails and
since you don't touch the original data no risk involved
One thing that is worth looking at, however, is users with the IP/hostname of
the old host in them - those may need to be changed if the related software is
also moved.
Also, some Linux distributions do specific setup - Debian, for one, sets up a
debian-sys-maint user that gets used for clean startup/shutdown/upgrade tasks.
Both copying over the datafiles and importing a mysqldump from the old db will
destroy that user entry, so it needs to be recreated manually afterwards. Other
distributions may or may not have their own quirks.
as said copy it to the new machine and you are done - why do people
these days not just try out things, look if it works and when it don't
asking questions?
Eh. Sometimes it's comforting to get someone else's opinion before messing with
production systems you're not an expert on
really?
when you *copy* the datadir on the target machine nobody eats your data
on the old one away and hence you can try out how it behaves on the new
machine without any risk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql