Re: MySQL Platform Migration

2016-09-12 Thread Harrie Robins
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 migr

Re: MySQL Platform Migration

2016-09-12 Thread 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 whi

RE: my.cnf authencication

2016-01-29 Thread Harrie Robins
ump] 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 authen

my.cnf authencication

2016-01-29 Thread 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