Hi Mike,
First, please don't use all capital letters in posts or thread titles. It looks like you're shouting. Please talk, don't shout.
Second, please re-read your post and ask yourself how much information you have provided us about your situation. It isn't much. The more we know, the more we can help. Please read
this thread and use its advice as the basis for your next post.
Third, it sounds like you're saying you have ten tables that are each 500 GB in size. That's 5 TB. Is your database
really that large? If it is, you should expect a somewhat time-consuming dump and load. Of course, without any specifics at all, we don't know how time-consuming it is or whether it is longer than it should be or could be.
Please read the thread I linked to and provide some details about your situation. Thanks.