From: Philip Wilkinson
Date: March 13 1999 4:08pm
Subject: List-Unsubscribe
List-Archive: http://lists.mysql.com/mysql/165
Message-Id: <005201be6d6b$c8645760$9f4f883e@barney>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

List-Unsubscribe
-----Original Message-----
From: Van <vanboers@stripped>
To: Jochen Haeberle <listen@stripped>
Cc: Mysql <mysql@stripped>
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
>
>