From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1Q7biJ-0005yN-LK for garchives@archives.gentoo.org; Wed, 06 Apr 2011 23:00:39 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 609F11C006; Wed, 6 Apr 2011 22:59:16 +0000 (UTC) Received: from www01.badapple.net (www01.badapple.net [64.79.219.163]) by pigeon.gentoo.org (Postfix) with ESMTP id 369A01C006 for ; Wed, 6 Apr 2011 22:59:16 +0000 (UTC) Received: from [127.0.0.1] (173-8-169-73-SFBA.hfc.comcastbusiness.net [173.8.169.73]) (Authenticated sender: ramin@badapple.net) by www01.badapple.net (Postfix) with ESMTPSA id 947278446021 for ; Wed, 6 Apr 2011 15:59:15 -0700 (PDT) Message-ID: <4D9CF046.3000703@badapple.net> Date: Wed, 06 Apr 2011 15:59:18 -0700 From: kashani User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9 Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] putting mysql databases from one system to another References: <7679.1302029984@ccs.covici.com> <4D9CA2C2.6070107@badapple.net> <201104070047.54336.wonko@wonkology.org> In-Reply-To: <201104070047.54336.wonko@wonkology.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Archives-Salt: X-Archives-Hash: 168afe0e09aac5746c4a017cdaa5db69 On 4/6/2011 3:47 PM, Alex Schuster wrote: >> On Linux there is no difference between the on disk format so rsync >> away assuming you're keeping roughly the same Mysql version. > > Um, but only when the architecture is identical. I'm pretty sure binary data > is stored in different format on 32bit and 64bit systems. > > Wonko > I had done it myself in the past a number of times without issue, but here's the documentation to back it up. kashani http://wikis.sun.com/display/WebStack/MySQL64bitARC "It should be noted that, when switching between 32bit and 64bit server using the same data-files, all the current major storage engines (with one exception) are architecture neutral, both in endian-ness and bit size. You should be able to copy a 64-bit or 32-bit DB either way, and even between platforms without problems for MyISAM, InnoDB and NDB. For other engines it doesn't matter (CSV, MEMORY, MERGE, BLACKHOLE and FEDERATED) either the engine doesn't have a disk storage format or the format they use is text based (CSV) or based on MyISAM (MERGE; and therefore not an issue). The only exception is Falcon, which is only available in MySQL 6.0. It is generally recommended from MySQL that a dump and reload of data for absolute compatibility for any engine and major migration."