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

[Stephen Ticehurst]

I would second what Oliver suggests.   Stop mysql and just rsync over the actual db files rather than doing the import and export which could take multiple hours.

If you want it secure copy then use rsync over ssh



* Oliver Marshall (oliver.marshall at g2support.com) wrote:
> 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
> -- 
> 
> BNM Subscribe/Unsubscribe:
> http://www.brightonnewmedia.org/options/bnmlist
> 
> BNM powered by Wessex Networks:
> http://www.wessexnetworks.com

-- 

Stephen Ticehurst
sticehurst at jtsr.co.uk	http://trabant.moleville.co.uk/
			http://books.moleville.co.uk/