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

[Alessandro De Maria]

Well.. Have you ever used mysqldump on > 2 GB? If not good luck;)

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 ;)



Alessandro De Maria
alessandro.demaria at gmail.com


On 3 Dec 2008, at 08:50, David Pashley <david at davidpashley.com> wrote:

> On Dec 02, 2008 at 23:25, Alessandro De Maria praised the llamas by  
> saying:
>> .
>> You should use mysql_hotcopy to backup the files, instead of
>> mysql_dump, or it will take you hours to restore it :P
>>
> Remembering to use --opt make mysqldump a lot quicker to import. :)
>
> -- 
> 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