data migration

[Eric Antunes]

Hi Edgar,

Did you did it?

The next time you may consider renting a VPN for a week between the 2 locations: I think this is the best way to transfer huge amounts of data between to remote sites...

Best Regards,

Eric Antunes

[Edgar_8]

Hi Eric/All,

Yeah we managed to do the full DB import in approx.36hrs and all is well with the DB. All things considered I know that we will follow the same steps should we need to in the future with such a large DB migration, unless we have otther options at our disposal.
Aagain thanks for all the advice & suggestions it was most appreciated. Below are the steps we took:
1. made a full DB export,therefore 1 43GB compressed dump file.
2. ftp'd data to new location
3. imported compressed dump file using a unix pipe
4. recompiled all invalid objects.