G
Gareth Vincent
Guest
Hi Ahmed, I would also recommend a binary dump and load. When dumping out the data I would suggest setting your -B as large as possible. Another option is to use the -i param when loading your data (worse case you would have to reload if errors occur). This parameter is a huge time-saver. Paul Koufalis gave a great presentation on this at the last EMEA Conference. The presentations are available for download, i'm sure Pieter has them already.
Continue reading...
Continue reading...