Re: MySQL Platform Migration

[Harrie Robins]

Hi,
.
It is bad practice to do so in my eyes (and yes that is an *opinion*). When
you advice people, instruct them to take the proven route, as described in
the mysql documentation.
Second, mastering mysqldump should be golden standard for any DBA. Telling
someone that asks for guidance to simply copy around some files is bad
practice as you do not know the level of expertise involved.

Regards,

Harrie

On 12 September 2016 at 11:03, Reindl Harald  wrote:

>
>
> Am 12.09.2016 um 10:48 schrieb Harrie Robins:
>
>> Ok let's drop this. Simply copying files to migrate a server is not the
>> approach to take (in my humble opinion)
>>
>
> And why?
>
> When you start with "Get the same release-version of mysql running on the
> target platform" and dump/load what's the point in playing around with
> dump-files when you hava binary datafiles which can be used on the
> destination
>
> and no - i am not talking about theory
>
> i migrated a hosting-infrastructure with dozens of servers from OSX PPC to
> OSX Intel and later to Linux x86_64 with just rsync the mysql-datadir
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>

Re: MySQL Platform Migration

[Harrie Robins]

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  --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"  wrote:
>
> >Because they want to be belittled by european jackasses online.
> >
> >On Sep 10, 2016, at 11:56 PM, Reindl Harald 
> >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 
> >>> 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
>
>

RE: my.cnf authencication

[Harrie Robins]

Thanks for the reply - that was indeed a typo. I resolved this buy making these 
changes:

mysqldump --defaults-extra-file="c:\sql\dump.cnf" dname > c:\loc

with my cnf containing:

[client]
user = user
password = pass

Looks like I misplaced "" and or [client] / [mysqldump] in the cnf

Thanks



-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be] 
Sent: vrijdag 29 januari 2016 15:06
To: Harrie Robins 
Cc: MySql 
Subject: Re: my.cnf authencication

- Original Message -
> From: "Harrie Robins" 
> Subject: my.cnf authencication
> 
> mysqldump --defaults-file  dbase > c:\sql\dbase.sql 2>> c:\log.tct

Might just be a typo in your mail, but you'll need to actually pass the 
defaults-file, too: --defaults-file=c:\sql\dump.cnf .

I think there may be another typo somewhere, too, as it seems to think that 
lts-file is the user you're passing. I'm wondering if you haven't accidentally 
put only a single - in front of defaults-file.


> 
> 
> My log shows:
> 
> mysqldump: Got error: 1045: Access denied for user 
> 'lts-file=c:\sql\dump.cnf'@'localhost' (using password: NO) when 
> trying to connect
> 
> It looks like credentials are not filled in!?
> 
> Regards,
> 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql

--
Unhappiness is discouraged and will be corrected with kitten pictures.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

my.cnf authencication

[Harrie Robins]

I'm running a mysqldump in windows and I'm mailing 2>> output, right now I get 
this annoying 'insecure' error that pollutes my log. So I figured I use 
--defaults-file and set:

In c:\sql\dump.cnf

[mysqldump]
user = myuser
password = pass

my line looks like this

mysqldump --defaults-file  dbase > c:\sql\dbase.sql 2>> c:\log.tct


My log shows:

mysqldump: Got error: 1045: Access denied for user 
'lts-file=c:\sql\dump.cnf'@'localhost' (using password: NO) when trying to 
connect

It looks like credentials are not filled in!?

Regards,



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql