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

[David Pashley]

On Dec 03, 2008 at 09:50, Alessandro De Maria praised the llamas by saying:
> Well.. Have you ever used mysqldump on > 2 GB? If not good luck;)

Yes, daily. Have three databases in the 20-30GB dump size. Data file is
in the 110GB area.
> 
> The problems that are not solved by the --opt are:
> 
> Still slooooower to Import than mysqlhotcopy
> The size of the backup is a lot bigger. You would have to compress  
> (and decompress)
> Importing from an older version can stop due to silly SQL errors and  
> would leave you with a big headacke.
> 
> My database was 35 GB. mysqldump is just not meant to be used for  
> these sizes of DBs ;)
> 
MySQL is not meant to be used with databases that size, but that's a
different argument.

Hmmm mysqlhotcopy is only meant to be used for MyISAM and ARCHIVE
tables. Won't do InnoDB, which everyone should be using.

-- 
David Pashley
david at davidpashley.com
Nihil curo de ista tua stulta superstitione.