List:General Discussion« Previous MessageNext Message »
From:alex ye Date:October 5 2004 4:58pm
Subject:Re: Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system?
View as plain text  
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 <alexye2008@stripped> wrote:
Thanks for all your help!

Ted Byrne wrote:
I'm by no means an expert on this, but some things you might want to 
consider...

An alternative method to not impact the disk space on the 32-bit system:
If you have connectivity between the 32-bit and 64-bit systems is to use 
mysqldump on the 64-bit system and specify the 32-bit host using the -h 
switch.

This could take quite a while, depending on the throughput you can get 
across your network. (It's also possible that you may not have adequate 
disk space on the new system.) However, it would effective 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 wrote:
>Thanks Eric.
>But our data is very big(about 400G), server don't have enough disk space 
>and it will take long time to finish the dump.
> It may cause problem to floats if just copy data files to a 64 bit system?
>
>--Alex
>
>
>Eric Bergen wrote:
>The safest thing you 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 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 of spam? Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> >
>
>
>
>--
>Eric Bergen
>eric.bergen@stripped
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
>
>---------------------------------
>Do you Yahoo!?
>Yahoo! Mail Address AutoComplete - You start. We finish.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1




---------------------------------
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
		
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
Thread
Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system?alex ye5 Oct
  • Re: Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system?Eric Bergen5 Oct
    • Re: Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system?alex ye5 Oct
      • Re: Does anyone has the experience on migrating mysql serverfrom 32bit sysem to a 64bit system?Ted Byrne5 Oct
        • Re: Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system?alex ye5 Oct
          • Re: Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system?alex ye5 Oct