Hi there. Regarding the Database, actually you dont have to change anything. If the mirror on DH is set to mirror the actual hostname to the subdomain. then the domainname will resolve to the files in the subdomain where you did all the staging work, and hence the database connection, but appear to be at www.domain.com
I didnt intend to have a different database for my staging site vs. my live site.
I would like to go in and do the correct housekeeping to be able to have the DRUPAL site/files under the Fully Qualified Domain name and not the subdomain any longer but I'm not sure what that entails to be honest. Scott said that you can:
"7- Edit your Drupal site so it uses the new URL (example.com instead of drupal.example.com). This may be in a config file, or through the admin panel in Drupal."
But I do believe you can run it on the dreamhosters.com Subdomain being mirrored from the true domain indefinately.
Lets talk more as I would like some added info on this myself.
So far my project worked out fine as I described above. When I flipped the DNS the DRUPAL site at subdomain.dreamhosters.com (mirror of actual domain) shows!