On Fri, Apr 25, 2008 at 12:08 PM, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
> 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" <[EMAIL PROTECTED]> wrote: > > > > > > > On Fri, Apr 25, 2008 at 11:45 AM, Olaf Stein > > > <[EMAIL PROTECTED]> 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 > I know you can take a mysqldump and copy over the data directory. I not sure what you mean by binary copy. Can you please explain? We have one database in memory that why we are moving over to 64bit. I'm planing like a year ahead of time.