Re: Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system?

2004-10-05 Thread alex ye
For now it take us 12 hours to copy the data by using "scp", it will probablly take us 1 week to finish the mysqldump.it takes too long, we dont want do it. We are not useing any float type columns in our tables, is it still ok to copy? Thank you!! --Alex alex ye <[EMAIL PROT

Re: Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system?

2004-10-04 Thread alex ye
ve at preserving your data. It would be worthwhile testing this on a small subset of your data, with and without the -C switch. It might also be possible to pipe the mysqldump output to gzip so that the size of your resultant disk file(s) would be minimized. Ted At 11:20 PM 10/4/2004, alex ye wro

Re: Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system?

2004-10-04 Thread alex ye
u can do to protect floats and the like is to use mysqldump to dump them to a .sql on the 32 bit system then import them again on the 64 bit system. -Eric On Mon, 4 Oct 2004 16:38:13 -0700 (PDT), alex ye wrote: > Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit &

Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system?

2004-10-04 Thread alex ye
Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system? Can data files(from 32bit system) be readed properly by mysql server after copy to a 64bit system? Thank you in advance! --Alex __ Do You Yahoo!? Tired