Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Chuck Anderson
July 1, 2008, 11:54 pm
rate this thread
MySQL development software on my home PC and am wondering what sort of
folder structure others may have come up with that seems handy, easy to
backup, and modularized.
My setup has not changed much over the years. As of now I have:
All of my web sites and local web apps are under apache2.2/htdocs - and
I have placed any special binaries I have needed for them in a folder -
c:/apache2.2/bin (e.g., ... curl, exiftool, gzip, jpegtran, ...).
(By web apps, I mean applications I've created using Php/MySQL and
HTML/browser for the GUI; like a music catalog, calendar, photo
album/gallery, general purpose address book, etc. These only reside on
my local machine .. but can also be uploaded and used within web sites.)
I've actually never bothered using Virtual Host in my apache config
until just now, ..... and since I am going to begin doing that, I want
to reorganize everything.
I'm thinking of keeping Apache, Php and MySQL in their root based
folders (as above), but I want to reorganize my web sites and local web
apps. (Is there any advantage to putting everything under one big
folder like C:/server, then placing apache, mysql, and php as subfolders
there .... along with all the web sites and web applications? I'd also
like to make backups easy .... and have them fit onto one DVD (my web
sites and web apps - plus mysql/data are the only things that really
need backing up ... Php, Mysql and apache can always be reinstalled.)
One thought I have is to create a folder, C:/localhost, and then have
subfolders for my web apps and web sites, where the web sites will look
# and then subfolders
# and then subfolders
... and so on ....
... putting the actual websites into the public_html subfolder,
emulating the layout on the remote host - and setting up Virtual Hosting
(e.g., loc.website1.tld -> C:/localhost/website1/pubic_html) using
Apache config and the windows hosts file.
The web apps would simply be in a subfolder such as:
And I can put files used by more than one web application directly under
.... So phpMyAdmin would also go there:
I don't know if I should break this down more or not. I'm not sure what
to do with my "bin" files (above), but I think moving them under Program
Files might be more appropriate than the apache/bin folder I created
myself and have been using).
Before I commit to any one structure I was wondering if anyone has any
clever folder/sub-folder layouts ideas they'd like to share?
Chuck Anderson • Boulder, CO
Nothing he's got he really needs
Twenty first century schizoid man.