I am sure there are tons of you out there that know exactly how this works but I had to figure it out and unfortunately there wasn't one single article on how this would work with Drupal, SQL and 1and1.
As a subplot the reason I had to do this, other then needing to have database backups, was because I wanted to upgrade to the lastest version of Drupal and it requires MySQl 5.0 and higher. So that means exporting/backingup the original MySQl 4 database and then importing it into the newly created 5.0 database. Read more