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 < martinmuel...@northwestern.edu> 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.cole...@cwis.biz> wrote: > > >Because they want to be belittled by european jackasses online. > > > >On Sep 10, 2016, at 11:56 PM, Reindl Harald <h.rei...@thelounge.net> > >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.rei...@thelounge.net> > >>> To: mysql@lists.mysql.com > >>> 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 > >
