This gives a few notes on why I did it and how it was done.

In the course of building the Paopi site, we found that on my shared ssl account, the team could not get a civicrm civicontribute donation workflow to go all the way through to a payment processor.

The interns determined we would need a private ssl. To get one, we would need to finalize hosting for paopi. I worked with Mr. Angeles to finance this. It turns out for a shared hosting account, static IP, private SSL, bluehost would end up being $2 more expensive than hostgator. Also, hostgator had a plan offering that packaged up everything you need into a business plan for $10.36 per month when you bought 3 years of service.

We bought 3 years of service. I locked in to a paopi.org web address through godaddy since it was $5 per year cheaper than procuring the web address straight from hostgator. I changed the default name servers for paopi.org to point to the hostgator named servers.

Next, I had to move the site from bluehost.

Here's a checklist of things I had to do:

• Use phpmyadmin to export the paopi drupal and civicrm databases as .sql files. The drupal one which had most of the work done to it was about 20 megs. The civicrm was 2 or 3 meg.
• I had to edit the sql scripts on my home computer searching and replacing instances of foreignt, my bluehost shared host user with the appropriate web address (paopi.org) or directory settings that were present in hostgator.
• I had to create shell databases for paopi and paopicivicrm in hostgator and import the edited sql scripts from my home computer into them through the hostgator cpanel. I don't have ssh yet on hostgator because the request is still in.
• I had to create a hostgator mysql database user that had acces to the shell databases.
• I had to edit the sites/all/ civicrmsettings and settings.php files to change references to foreignt database users to the one I created on my hostgator account
• Some of these edits required temporarily chaning permissions on some locked files. Remember to change the permissions back to avoid any security holes.

That's pretty much it.