another option is to do a mysqldump and pipe it over to the new server, e.g: mysqldump --opt 32bitserver | mysql --host=64bithost -C 64bitserver
> ----- Original Message ---- > > From: Mike > > To: B. Keith Murphy > > Cc: mysql list > > Sent: Friday, 25 April, 2008 5:33:49 PM > > Subject: Re: Migration from 32-bit to 64-bit MySQL > > > > On Fri, Apr 25, 2008 at 12:08 PM, B. Keith Murphy > > 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" wrote: > > > > > > > > > > > > > On Fri, Apr 25, 2008 at 11:45 AM, Olaf Stein > > > > > 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. > > > > > > > ___________________________________________________________ > Yahoo! For Good. Give and get cool things for free, reduce waste and help our > planet. Plus find hidden Yahoo! treasure > > http://green.yahoo.com/uk/earth-day/ > __________________________________________________________ Sent from Yahoo! Mail. A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
