View Single Post

   
  #8 (permalink)  
Old 04-29-2008, 08:27 PM
Mike
 
Posts: n/a
Default Re: Migration from 32-bit to 64-bit MySQL

That what I want to do, but I'm not sure if the data will propagate right.
Because of lack of documentation for 64bit.

On Fri, Apr 25, 2008 at 12:03 PM, Olaf Stein <
olaf.stein@nationwidechildrens.org> 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?
>
>


Reply With Quote