Apache2Triad Help, Support and Development

[shawngibson]

I have 3 drives for this (excluding backup and Photoshop scratch): currently:

C: is all my WinXP-only regular stuff and development apps (Photoshop and Flash, in a nutshell);

D: is currently the entire package of Apache2Triad AND ColdFusion AND Flex 2 + the free Flex Data Services 2; including all my web apps, databases and web-access files. I would like to be able to move all the databases (the db's IN MySQL, not MySQL itself) and web-access files (i.e., everything at htdocs) to:

E: as it's my uber-fast and pretty big 150G Raptor - CURRENTLY EMPTY.

...but want to keep keep all the web APPS (servers etc.) on D:

Is this possible?

In other words, this would be perfect:

c: Win OS and development Apps (excluding Flex2+FDS2) and whatever other crap (image viewers and I gotta have my iTunes!)

d: apache2triad apps and coldfusion and flex apps)

e: all my web-accessible files and databases

and...

f: all my backup crap

g: scratch drive for photoshop

They're all Raptors, but the web Apps and Win are 74Gb as is the scratch drive, the other 2 (data and databases; backups) are both 150Gb Raptors.

I'm pretty sure, but certainly not positive, I'd change the https.conf file, but not sure what else I'd do. Luckily, it's a brand new install, so there's no data, just a blank db in MySQL right now.

I'm having a tough time with everything BUT Apache2Triad (what else is new!) so I'd like to go slow until it's all correct, then Ghost the whole thing.

Any suggestions would be much appreciated.

Shawn

[Vlad Alexa Mancini]

to move mysql db's edit windir my.ini
Quote: datadir = C:/apache2triadpath/mysql/data
move data dir from a2t to new place

to move sites create aliases ex:
http://httpd.apache.org/docs/2.0/mod/mod_alias.html
Code: Alias /moodle d:/moodle/dir 
or use virtual hosts

[shawngibson]

Awesome, thanks very much. Do you know if I am doing something drastically wrong by trying to get coldfusion as well to read from the MySQL app in your bundle? I couldn't make it work, and my only workaround seemed to be to install ANOTHER MySQL 5.0 but on port 3307...it seems to sort of work, but it is far from perfect, and it can't possibly be the correct way. do you know how i can get both PHP and ColdFusion to have active access to a single installation of mysql (different databases though...)?

I can get PHP to work, or CF, but not both on the same installation of mysql. My only way has been your install on port 3306, and a completely different install on port 3307, but it's really buggy.

Once I have everything set up properly, I can go and reconfigure everything to the proper drives as you noted. Much appreciated for any help or info on where to find it.

I refuse to use anything but your bundle, and I refuse to run coldfusion/JRun4 without being under your install of Apache and MySQL. Your package has proven rock-solid and bulletproof to me for several years now. I trust it more than anything I've yet to use. Now I am afraid I will have to try to learn Java to get CF running properly, the reason being that I can use Flex 2 and Flex Data Services and the native data handling of Flex. I'm a designer, not a developer, but am pressed into building a few apps that require heavy db use.

Shawn

[Vlad Alexa Mancini]

mysql in a2t only listens on 127.0.0.1 , make sure you connect to that
also coldfusion might have the option of using ODBC instead of a direct connection to mysql , see http://apache2triad.net/forums/viewtopic.php?t=1407 for a similar thing with postgresql

[shawngibson]

Excellent, thanks, the instructions in the link *basically* make sense.

The only problem with A2T is that it works so perfectly, so I've never had to actually pay attention to anything except Flash, MySQL via phpMyAdmin, and some PHP. Wow, what a shock the real world is, and if not for kind people like you, people like me would be coding html pages asking 'what's a javascrib?'...

:)

Shawn