install and setup
Our directories and urls:
Put the html files here:
> HTML -> /net/www3s-int/projects/anival
See them here:
> URL https://www3-int.cc.gatech.edu/wwws/projects/anival
Put the php files here:
> PHP -> /net/php3s-int/projects/anival
See them here:
> URL https://cgi3-int.cc.gatech.edu/phps/projects/anival
Put the MySQL files here:
> DB -> /net/wwwdb2/projects/anival
Our host, this is where you should do the work from with the database:
messena.cc.gatech.edu
The long way to make the daemon run:
bin/safe_mysqld –defaults-extra-file=/net/wwwdb2/projects/anival/mysql/data/my.cnf –log=/net/wwwdb2/projects/anival/mysql/data/messena.err –user=mysql –port=19170 –socket=/tmp/anival.sock &
The short way (my.cnf content is copied below, it should be in the mysql folder still):
bin/safe_mysqld –defaults-extra-file=/net/wwwdb2/projects/anival/mysql/data/my.cnf &
These are different commands to start the database:
This is the main one:
bin/mysql –defaults-extra-file=/net/wwwdb2/projects/anival/mysql/data/my.cnf -u root mysql
(-u )
this last part is really up to who's running what database. Its the default-extra-files part that is more important here.
The rest were used mostly for testing:
bin/mysql –host=messena –port=19170 –socket=/tmp/anival.sock -u bb -p phpbb_db
bin/mysql –defaults-extra-file=/net/wwwdb2/projects/anival/mysql/data/my.cnf -h messena -u bb -p phpbb_db
There's a create_database.sql in the mysql folder. It basically contains all the information you are expected to use to create the database in one file. That way you don't have to keep entering it in the command line. It makes creating the database for the forum easier.
I got most of the settings from Jose's MySQL and PHP book, you can find it in there if you have questions about the settings:
bin/mysql -u root -p create_database.sql
This one was just used for testing on terel to fix the problem with a missing library, you shouldn't ever need it:
bin/mysql.terel –host=messena.cc.gatech.edu –port=19170 -u bb -p phpbb_db