I've been following a tutorial for installing the wiki on my ibook.
I'm stumped by the following direction:
"There's a little bit more database stuff to do, and then a bit of PHPwiki stuff, and then it should work. First, for the database, in the PHPwiki distribution that you unpacked there's a directory called "schemas". Go there and issue this command: /usr/local/mysql/bin/mysql -uroot -p[password you just set in mysql] wiki < mysql.sql.
That sets up the database structure for the Wiki so that it's ready for the content, make sure you specify the password you set for the root account here."
I see the schemas folder. I don't know how to "go there" to issue the command. When I try going into the terminal and pasting in the command, it doesn't work. I don't know how to get into the schema area to issue my command.
Please help! You can post here or email me at thewendster@gmail.com
Thanks!
Wendy
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Once it is installed, you will need to set up a database area for MySQL to manage. See the instructions from MySQL to do that. If you have never done databases, expect a learning curve. If you have trouble on the command line, expect a steep learning curve.
Then you would issue that command to create the schemas.
After that, you need to relink PHP to have the mysql client in it. Then install that new .so into the Web server's modules directory (/usr/libexec/httpd). You may need to touch up /etc/httpd.conf a little bit too.
Then you will need to activate the web server in the Apple | System Preferences | Sharing | Personal Web Sharing. This is not turned on by default in OS X.
Or
As another spoke of - it would be far more simple to use the storage of files - you simply say in the config.inc where to put the goods and it is pretty automatic from there.
You will still need to turn the web server on as above. You will likely want to put your php code in /Library/WebServer/Documents/phpwiki to reach it as http://localhost/phpwiki.
Be aware on major upgrades, you will probably need to repeat some of these steps. So back up before doing an upgrade (like Panther to Tiger - minor upgrades don't trouble it much unless it is to PHP, etc.) My experience going from Panther to Tiger was the wiping out of the /usr directory and replacing it with OS stuff and wiping out of the /Library/WebServer directories and replacing it with new OS stuff. They delete and replace, not merge, when doing the upgrade. (I was quite disappointed but at least I had backups to save some of the work.)
P.S. for the UNIX types, Apple iBooks using OS X is just like BSD/Linux on the Terminal program - right down to the ls command. It is based on BSD.
P.S.S. I am giving these instructions based on OS X on a Powerbook - shouldn't be much different.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I've been following a tutorial for installing the wiki on my ibook.
I'm stumped by the following direction:
"There's a little bit more database stuff to do, and then a bit of PHPwiki stuff, and then it should work. First, for the database, in the PHPwiki distribution that you unpacked there's a directory called "schemas". Go there and issue this command: /usr/local/mysql/bin/mysql -uroot -p[password you just set in mysql] wiki < mysql.sql.
That sets up the database structure for the Wiki so that it's ready for the content, make sure you specify the password you set for the root account here."
I see the schemas folder. I don't know how to "go there" to issue the command. When I try going into the terminal and pasting in the command, it doesn't work. I don't know how to get into the schema area to issue my command.
Please help! You can post here or email me at thewendster@gmail.com
Thanks!
Wendy
MySQL is not installed on OS X by default (yet), so you need to download and install that first:
http://dev.mysql.com/downloads/mysql/5.0.html
Once it is installed, you will need to set up a database area for MySQL to manage. See the instructions from MySQL to do that. If you have never done databases, expect a learning curve. If you have trouble on the command line, expect a steep learning curve.
Then you would issue that command to create the schemas.
After that, you need to relink PHP to have the mysql client in it. Then install that new .so into the Web server's modules directory (/usr/libexec/httpd). You may need to touch up /etc/httpd.conf a little bit too.
Then you will need to activate the web server in the Apple | System Preferences | Sharing | Personal Web Sharing. This is not turned on by default in OS X.
Or
As another spoke of - it would be far more simple to use the storage of files - you simply say in the config.inc where to put the goods and it is pretty automatic from there.
You will still need to turn the web server on as above. You will likely want to put your php code in /Library/WebServer/Documents/phpwiki to reach it as http://localhost/phpwiki.
Be aware on major upgrades, you will probably need to repeat some of these steps. So back up before doing an upgrade (like Panther to Tiger - minor upgrades don't trouble it much unless it is to PHP, etc.) My experience going from Panther to Tiger was the wiping out of the /usr directory and replacing it with OS stuff and wiping out of the /Library/WebServer directories and replacing it with new OS stuff. They delete and replace, not merge, when doing the upgrade. (I was quite disappointed but at least I had backups to save some of the work.)
P.S. for the UNIX types, Apple iBooks using OS X is just like BSD/Linux on the Terminal program - right down to the ls command. It is based on BSD.
P.S.S. I am giving these instructions based on OS X on a Powerbook - shouldn't be much different.
Sorry, I know nothing about shell commandos on a ibook.
Why don't you just use the default setup, without SQL database?
DBA is the default.