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

[Oliver Marshall]

I use Rsync to do large copies from box to box. Its reliable, as fast as anything else, and also has the added benefit of only copying files that have changed should you have to re-do the copy later on.

As for doing the mysql, the easiest way would be to do a dump of the DBs and then re=import them later on. Alternatively you could copy the DB files (/var/lib/mysql i *think* off the top of my head) and the mysql.cnf file from /etc/mysql (again, best to check that location). That will copy the entire mysql setup, along with db's and schemas, permissions etc. You can do that with Rsync too. Be sure to stop mysql on both boxes before you do the copy.

Olly

--
G2 Support
Online Backups

Email:  oliver.marshall at g2support.com
Web:    http://www.g2support.com




-----Original Message-----
From: bnmlist-bounces at brightonnewmedia.org [mailto:bnmlist-bounces at brightonnewmedia.org] On Behalf Of James Moss
Sent: 02 December 2008 14:39
To: Brighton New Media
Subject: [BNM] Transferring 60GB of files from one server to another

Hi guys,

Im working on a side project and we've just had a fast shiny new linux
server installed for us to replace the old one.  However we've got 60GB of
files in the wwwroot folder which need to be transferred to the new server
over the gigabit network.  Whats the fastest way of doing it? Is SSHing in
and doing an FTP transfer fast enough or is there a better way?

Weve also got a fairly large DB (its just under 5GB, 3.5GB of which is a
single table).  Whats the best way of getting that across too?  I was
planning on dumping the current one to an .sql file and executing it on the
new server but i presume the inserts will take aaaaages.

Cheers,
James.
--

BNM Subscribe/Unsubscribe:
http://www.brightonnewmedia.org/options/bnmlist

BNM powered by Wessex Networks:
http://www.wessexnetworks.com