Web lists-archives.com

Re: MySQL Platform Migration




Ok let's drop this. Simply copying files to migrate a server is not the
approach to take (in my humble opinion).

First asses the situation, a platform migration? Get the same
release-version of mysql running on the target platform. Dump your mysql
database the with the excellent tool mysqldump which is shipped with mysql:
mysqldump -u root -p <pass> --all-databases > target.sql

Now import the databases: mysql -u root -p --execute="source
database_dump.sql" --force"

This will overwrite all databases including the mysql-table which contains
users. Make sure to run mysql_upgrade next to fix any inconsistancy's.
Restart mysql or flush privs > done.

Regards,

Harrie

On 11 September 2016 at 21:53, Martin Mueller <
martinmueller@xxxxxxxxxxxxxxxx> wrote:

> Not very helpful rhetoric on either side of the fence. Every time an
> unnecessary comment is made, some time cost is imposed on the folks who
> make the mistake of opening the email thinking there was some useful
> advice.
>
> Civilization and good manners consist very largely of bitten tongues. And
> biting your tongue might be a good thing for others
>
> MM
> Martin Mueller
>
> Professor emeritus of English and Classics
> Northwestern University
>
>
>
>
> On 9/11/16 12:27 PM, "Ryan Coleman" <ryan.coleman@xxxxxxxx> wrote:
>
> >Because they want to be belittled by european jackasses online.
> >
> >On Sep 10, 2016, at 11:56 PM, Reindl Harald <h.reindl@xxxxxxxxxxxxx>
> >wrote:
> >>
> >>
> >> Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal:
> >>> Is the mysql datafile compatible with different operation system ? I
> >>>have not done this in the past.
> >>
> >> why shouldn't it when the identical software is running?
> >> it's just a bunch of files used by mysql
> >>
> >> 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?
> >>
> >>> ----- Original Message -----
> >>> From: Reindl Harald <h.reindl@xxxxxxxxxxxxx>
> >>> To: mysql@xxxxxxxxxxxxxxx
> >>> Sent: Saturday, September 10, 2016 7:19 PM
> >>> Subject: Re: MySQL Platform Migration
> >>>
> >>> Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal:
> >>>> Is there any documentation for migrating mysql 5.0 database from
> >>>>darwin to Linux
> >>>
> >>> what do you need to migrate?
> >>>
> >>> shutdown mysqld, copy the datadir to the new machine, start mysqld with
> >>> adopted configuration on the new machine - done
> >>>
> >>> P.S:
> >>> don't cross-post on mysql and mariadb list
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives:
> >>https://urldefense.proofpoint.com/v2/url?u=http-
> 3A__lists.mysql.com_mysql
> >>&d=CwIFAg&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=
> rG8zxOdssqSzDRz
> >>4x1GLlmLOW60xyVXydxwnJZpkxbk&m=cQyy1LyUdO1_o4_3K62-
> IxYpnXPNhcErgHZ2NXXmnT
> >>c&s=tiL5vs-xwiEX93V1KAJ7sw4QOg-ZD1qBrflS_f0lMow&e=
> >> To unsubscribe:
> >>https://urldefense.proofpoint.com/v2/url?u=http-
> 3A__lists.mysql.com_mysql
> >>&d=CwIFAg&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=
> rG8zxOdssqSzDRz
> >>4x1GLlmLOW60xyVXydxwnJZpkxbk&m=cQyy1LyUdO1_o4_3K62-
> IxYpnXPNhcErgHZ2NXXmnT
> >>c&s=tiL5vs-xwiEX93V1KAJ7sw4QOg-ZD1qBrflS_f0lMow&e=
> >>
> >
> >
> >--
> >MySQL General Mailing List
> >For list archives:
> >https://urldefense.proofpoint.com/v2/url?u=http-
> 3A__lists.mysql.com_mysql&
> >d=CwIFAg&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=
> rG8zxOdssqSzDRz4x
> >1GLlmLOW60xyVXydxwnJZpkxbk&m=cQyy1LyUdO1_o4_3K62-
> IxYpnXPNhcErgHZ2NXXmnTc&s
> >=tiL5vs-xwiEX93V1KAJ7sw4QOg-ZD1qBrflS_f0lMow&e=
> >To unsubscribe:
> >https://urldefense.proofpoint.com/v2/url?u=http-
> 3A__lists.mysql.com_mysql&
> >d=CwIFAg&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=
> rG8zxOdssqSzDRz4x
> >1GLlmLOW60xyVXydxwnJZpkxbk&m=cQyy1LyUdO1_o4_3K62-
> IxYpnXPNhcErgHZ2NXXmnTc&s
> >=tiL5vs-xwiEX93V1KAJ7sw4QOg-ZD1qBrflS_f0lMow&e=
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>