Installing Drupal on 1and1 servers.
As most first times (or first couple of times), installing Drupal wasn’t as easy as expected but it should have been if I was better prepared.
Now, I think I could do it in my sleep. ;-)
So the first thing you will need in a non MS hosting plan from 1and1. I have the Business plan, but any of the accounts should do. If you look at the comparison chart, they all do PHP and SQL.
Note: Yes I know you can do it under IIS, but I didn’t do it that way. In fact, Imoved to the Linux package from an MS one just to install Drupal
Now you need to download the latest version of Drupal from http://drupal.org/project/Drupal+project.
Unzip, oops, untar the file to someplace in your hard drive like x:\drupal\drupal-#.#.#, but any place that you can get to (and remember) will be fine.
Now go to your 1and1 admin web page at http://admin.1and1.com and log in. You will need to create a SQL database. Make sure you are on the Administrator TAB and click the MySQL Administration icon.
Now create a new database by clicking the “New Database’ button. Give the database a description. Doesn’t really matter what you put here, just something that you will remember. I put the name of the site someone in this description, to easily identify it. Believe me, you will need it, especially if you are going to create more SQL databases.
Once you have a description, click the “Set Up” button.
1and1 will give you some info on the database it is creating. The info you will need is:
Database name: db#########
Host name: db###.perfora.net
User name: dbo#########
Notice that the numbers in database name and user name are the same, but user name adds the letter “o”.
Now, click on the “Go To Overview” button.
It might take a couple of minutes for the database to actually be created. Refresh the page a couple of times. You know the database was created when you see three button labeled: phpMyAdmin, Edit and Delete.
You need to load the scema (database structure?) that Drupal needs to work. To do that, just click on the “phpMyadmin” button. Another page will open.
On the left hand side of this page, under the icons, you should see the database name: db#########, click it.
You should now see a bunch of tabs on the top of main page. Click the SQL tab.
Do you see the “Browse” button? It is in between the 2 “Go” buttons. This is how you will add the schema, so click on the “Browse” button.
You need to find the database folder in the Drupal download. Should be something like x:\drupal\drupal-4.7.2\database. Select the file database.4.0.mysql and click open and now the second “Go” button. The data will be imported.
You are now done with this page, so close it.
FYI, I tried to use the database.4.1.mysql file assuming that it would be better, but got an error so I went with database.4.0.mysql.
Hopefully you are still on the MySQL Database Set Up and Configuration page on admin.1and1.com. If not, get back there.
Instead of writing the database info down somewhere, just leave your browser open and to this page. You can cut and paste from here to prevent typos.
If you left the browser open, minimize it and go to the directory where the Drupal files are, you have to do some editing.
Find the settings.php file in the x:\drupal\drupal-#.#.#\sites\default folder and open it. If you don’t have a specific program to do this, and you are using Windows, WordPad works while notepad doesn’t.
Search for $db_url =
Change the line from this:
$db_url = 'mysql://username:password@localhost/databasename';
To this, using the info from above:
$db_url = 'mysql://dbo#########:********@db###.perfora.net/ db#########';
That’s it for this document, save it.
Note: The following isn’t necessary to get Drupal up and running, but if you plan on using “Clean URls,” it probably easier to do it now before you upload the files to the server.
Find the .htaccess file in the x:\drupal\drupal-#.#.# folder and open it. Again, wordpad seems to work best.
Search for: #RewriteBase /drupal
And change it to: RewriteBase /
That’s it for this document, save it.
Now, just upload all files and folders in the x:\drupal\drupal-#.#.# folder to the root directory of your server using your favorite FTP program. Make sure there are no index.htm* files in the root directory.
Open up your browser and go to your web page. With any luck, you should see the Drupal log on page. Create the first account, and enjoy Drupaling.