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

[Karim Ahmed]

On Tue, Dec 2, 2008 at 8:38 PM, David Pashley <david at davidpashley.com>wrote:

> On Dec 02, 2008 at 17:44, Karim Ahmed praised the llamas by saying:
> > Yes, ftp is the most reliable method for transferring files. Why not
> upgrade
> > the mysql installation on the old server first then you know the raw db
> > files will be compatible. If you can't then I would recommend the
> slooooow
> > dump/upload method.
> >
> Of all the methods of transfering files, FTP is far from the one I would
> recommend. Even use scp is preferable to FTP.


I don't understand, FTP is widely used and the best known file transfer
protocol in the world so we all know it must be OK (or security, use SFTP
instead). What do you use instead and why David?

As for upgrading the existing server, you're asking for trouble by
> changing what is an already working system and one that will provide you
> with a fallback in case there is a problem with the new server. Dump and
> restore is the only solution I'd recommend, given that it gives you an
> opportunity to reclaim space used up by InnoDB database files. If you're
> not using InnoDB, then you should, and this is a good chance to do so
> and to make any database schema changes.


Best practice is to back-up on the local server _before_ the upgrade so that
a restore is your fallback. It will take seconds!

--
> David Pashley
> david at davidpashley.com
> Nihil curo de ista tua stulta superstitione.
> --
>
> BNM Subscribe/Unsubscribe:
> http://www.brightonnewmedia.org/options/bnmlist
>
> BNM powered by Wessex Networks:
> http://www.wessexnetworks.com
>