Hi all, first time post.
I have been using Drupal for my wife's business website for some time now and I really like it. I am running Drupal 6.2 on FreeBSD and I'm using Apache 2.2 as the web server and PostgreSQL as the db backend.
I am trying to setup a website for myself using Drupal with a separate database for my site. I created the appropriate folder under sites/ and copied the settings.php file. I created a new db and set that db name and password in the settings.php file. I also configured apache to handle the new virtual server.
The problem is that the database doesn't have any of the tables that it needs inside it, and I don't know how to get Drupal to create them.
I set world write on the settings.php file, I removed it altogether, I copied the default settings file into my new site directory too, hoping that at some point Drupal would see this as a new site and automatically create the tables in the database. None of these tricks made it work. At best I was able to get Drupal to throw up a default page stating that the site was misconfigured. I tried calling install.php and update.php on the new site but that didn't work either.
I suppose I could copy the database from my wife's site and delete all the content in it, but doesn't seem like the right way to do it. Alternatively I could hide her site content and try to trick Drupal in establishing another new site.
It seems to me that there should be a simple way to get the tables created in the new database. Does anyone have any insight into this?
Comments
Go to the domain and setup the site
Simply go to the domain you are trying to create (i.e. you just created sites/example.com). Assuming you have set DNS correctly, then going to example.com will give you the regular Drupal install / setup, which will prompt you for DB information and create the tables for you.
I tried that ...
All I get is a blank screen, that's why I tried the various combinations of missing settings.php files. Should I remove any and all settings.php from "sites/mysite.com" ???
SOLVED
Hah, somewhere I read about removing certain files from production Drupal sites. Flat files like "INSTALL.txt" "README.txt" and the like. Somehow install.php was also removed! Without this file, you can't setup any other sites.
So, make sure that install.php is in the document root!
Can anyone comment on the practice of removing these files from the document root?
Depends
INSTALL, README, and CHANGELOG can serve as indicators of the current version of your site, and potentially provide additional info for people looking for vulnerabilities. Removing them is optional.