Olaf Stein wrote:
> Probably not
>
> AFAIK it should work in theory if you have no floating point columns but I
> would not try it.
> Why cant you take a dump, you can do it table by table, you will have some
> downtime though.
>
> One option might be to use a 64bit slave and make that the master and then
> add more 64 slaves.
>
>
> On 4/25/08 11:57 AM, "Mike" <lunarblu@gmail.com> wrote:
>
>
>> On Fri, Apr 25, 2008 at 11:45 AM, Olaf Stein
>> <olaf.stein@nationwidechildrens.org> wrote:
>>
>>> As long as you use dumps to restore your databases on the new 64bit system
>>> (instead of the binary files) you should be fine
>>>
>>> Olaf
>>>
>> I have so much data that we can't take a mysqldump of our database. The
>> directory tared is about 18GB. I just use the other method by just copying
>> over the data directory. Do you think the data will be intact if a just copy
>> over the data directory?
>>
>>
>
>
Seriously, 18 gb isn't too big to do a mysqldump. And I really wouldn't
advise you trying to do a binary copy. You are just asking for trouble.
Plan ahead and you can do this on a slave without any problem, import
the data on the new server and sync it back up without any problems.

--
Keith Murphy


editor: MySQL Magazine
http://www.mysqlzine.net