S
sfgaarthuis
Guest
When will the customer be satisfied? How many hours wil be okay for him? What is the maximum number of hours they want/can be down. For these kind of actions i allways use binary dump & load. Can also be done in parallel. For fast dumps of large tables the primary index may not be the right one. Look for an index with a date if records are added daily and use this index instead of the primary. You may need to do some dump tests. And why do you want to all at once? Why not db after db. No real solution, just some thoughts. Tom Bascom (Whitestar) could give you the best advice on this.
Continue reading...
Continue reading...