Ticket Options

Question Details

TICKET ARCHIVE -> Apache 2, Php, And Mysql

uillis - May 19, 2005 - 10:51 am

I'm learning all this on a PeeCee; however, when I get home my textbook, 'Data Driven Website' by Kevin Yank, is useless.

I've figured out how to install everything via the Terminal from sources on macphp.com; but the paths in my directory are not as straight forward as the PC, e.g.,
htdocs in the Apache 2 folder in the root is fine, but what is the httpd-2.0.54 folder all about.

Today, Iwanted to create a database and then install the backup from the PC with these commands:

mysqladmin -h localhost -uroot -pmypass create ijdb

mysql -hlocalhost -uroot -pmypass ijdb
Thing is, even if they had worked, I wouldn't have known where to place the backup file for it to be installed.

Is there a book out there for OSX Mac users to explain commands in Terminal and how to locate and work with paths?

Vile - May 20, 2005 - 2:32 am

Hi Will. Thanks for choosing MacOSX.com for your support issues.

The paths vary on every system, and every OS build. For instance, FreeBSD doesn't have htdocs, it has /usr/local/www, while Linux has /var/www/htdocs. You can set the root directory to any directory you want in your httpd.conf file.

For your soon to be aquired knowledge of Command Line Interface commands, you might look into various UNIX Shell books, or books about your OS in general. Even some various Linux books can get you in the right direction to learning the terminal, and file system setup.

As for the MySQL, that's a whole other book. O'rielly has an online MySQL book that has everything you could need for MySQL, and can also be purchased in paperback format.

--------