I have recently tried to move a large database to another host and I have encountered problems regarding this.
I have decided to document this so that other Drupal users may benefit from it.
There are many ways to restoring a database to different host but this has worked for me.
First, you need to have a working drush system in your both drupal installations.
Start with clearing all of your database cache
$cd /home/home/public_html or wherever is your root Drupal installation
$drush cc all