From: Philip Wilkinson Date: March 13 1999 6:46pm Subject: Re: List-Unsubscribe List-Archive: http://lists.mysql.com/mysql/175 Message-Id: <000701be6d81$bf33bbc0$dc2d883e@barney> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Can someone please tell me how to get off this LIST!!! -----Original Message----- From: Philip Wilkinson Cc: Mysql Date: Saturday, March 13, 1999 04:10 Subject: List-Unsubscribe >List-Unsubscribe >-----Original Message----- >From: Van >To: Jochen Haeberle >Cc: Mysql >Date: Saturday, March 13, 1999 03:54 >Subject: Re: Moving MySQL from one Linux Box to another > > >>Jochen Haeberle wrote: >> >>> Hi, >>> >>> I just read in the manual 4.16.3 Upgrading to another architecture >>> and will try the tips there to move my development MySQL to a new >>> production server. But I thought I could just copy all the database >>> files from one Linux-Box to another and use the exactly same >>> databases, users and data. >>> >>> I mounted the dev-server via nfs (rw) as root and tried to copy the >>> /var/mysql (cp -ar) most things went well, but several (not all) >>> files from the mysql subdir could not be copied with a permission >>> denied error. I shut mysql down with no difference. >>> >>> Is it possible to easily duplicate a MySQL-Installation from one >>> Intel-Linux to another keeping all data and users the same? >>> >>> Thanks in advance for helping a newbie (probably this is to be >>> considered OT, as I probably just was unable to just use Unix >>> correctly :-( ) >>> >>> Jochen >>> >> >>Jochen, >>Nothing beats good old fashioned tar and ftp. >>On old machine: >>cd /usr/local/var >>tar cvf /tmp/mydb.tar mydb >>(or sudo tar if permissions is a problem, which it shouldn't be) >>On new machine: >>ftp -i -v oldmachine >>uname >>pword >>cd /tmp >>bin >>get mydb.tar >>by >>cd /usr/local/var >>tar xvf mydb.tar >> >>Done. >>Van >> >>-- >>========================================================================= >>Linux rocks!!! www.dedserius.com >>========================================================================= >> >> >> >> >>--------------------------------------------------------------------- >>To request this thread, e-mail mysql-thread164@stripped >> >>To unsubscribe, e-mail the address in the List-Unsubscribe header. >>For additional commands, e-mail: mysql-help@stripped >> >> > > >--------------------------------------------------------------------- >To request this thread, e-mail mysql-thread165@stripped > >To unsubscribe, e-mail the address in the List-Unsubscribe header. >For additional commands, e-mail: mysql-help@stripped > >