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.

Here is some information that was sent to me by 1and1 tech support:

To update the version of your MySQL from 4 to 5, please check the link below: General FAQ To make a back up copy of your database (export and import), please check the link below: Export Import If you have any further questions please do not hesitate to contact us.

So here it goes:

To Backup the Original MySQL 4 Drupal Database

1. Log into to admin.1and1.com and then go to MySQl Administration. Now click on the "phpMyAdmin" for the original database that you need to backup.
2. The phpMyAdmin center will open in a new window. Click on the little icon that looks like a house in the top left corner.
3. Click Now just below that little 'house' will be the database name with a list of the database tables below that. Click on the database name (should be db1234567) and then to the right click on the new tab that says "Export".
4. Now click on "Select All" in red text. This will select all of the tables in your database for export.
5. Click on "Save As" and then click "Go"
6. Your web browser will ask where to save the file.
7. Close phpMyAdmin window.

To Create the New SQL 5.0 Drupal Database

1. Again make sure you closed the window that had phpMyAdmin center in it. If you don't then the old page might interfere with the new window.
2. Go back to the 1and1 MySQl Administration window
3. Click "New Database", name it and select php 5.0

To Import the Drupal Database

1. Once the new database is created and ready click on the "phpMyAdmin" button. The phpMyAdmin center will open in a new window.
2. This time click on the little "SQL" icon next to the little house icon. A new popup window will appear.
3. Click on the "Import SQL" tab and then browse for the original database file.
4. Click "GO" and your done... hopefully :)