[BNM] Transferring 60GB of files from one server to another

[Alessandro De Maria]

Hi,

remember to run mysql_upgrade after you copy the mysql files into the
new environment (before you start mysqld) as the file format changed
between mysql 5.0 and 5.1 and you would cause data corruption if you
did not run the conversion utlility
.
You should use mysql_hotcopy to backup the files, instead of
mysql_dump, or it will take you hours to restore it :P

All the method proposed for copying are valid, just make sure you use
something that keeps the permissions as well, otherwise you will have
to do a lot of work to put the right permissions back :P

Alex

On Tue, Dec 2, 2008 at 2:57 PM, James Moss <email at jamesmoss.co.uk> wrote:
> Thanks Olly, I'll look into rsync.
>
> As for the mysql, i was thinking about the /data directory too.  Would it
> matter if the mysql versions were slightly different (old is 5.0.22, new is
> 5.1.30).
>
> Possibility: Hook the existing hdd up to the new machine either internally
>> or with a usb > sata/ide adapter, and copy the files across. Always worked
>> for me in the past and is very quick.
>
>
> Unfortunately the server is up in Telehouse so I cant really do this, shame
> really as its probably the easiest option.
>
> Thanks for the help guys.
> James.
> --
>
> BNM Subscribe/Unsubscribe:
> http://www.brightonnewmedia.org/options/bnmlist
>
> BNM powered by Wessex Networks:
> http://www.wessexnetworks.com
>



-- 
Alessandro De Maria
alessandro.demaria at gmail.com
Niccolo Machiavelli - Whosoever desires constant success must change
his conduct with the times.

Mobile: 0044 789 5092951