i was able to upload everything, but im on the mysql part of the install. I dont even know where to start.

http://www.sehs.us/index.php

2. CREATE THE DRUPAL DATABASE

These instructions are for MySQL. If you are using another database,
check the database documentation. In the following examples,
"dba_user" is an example MySQL user which has the CREATE and GRANT
privileges. You will need to use the appropriate user name for your
system.

First, you must create a new database for your Drupal site:

$ mysqladmin -u dba_user -p create drupal

MySQL will prompt for the dba_user database password and then create
the initial database files. Next you must login and set the access
database rights:

$ mysql -u dba_user -p

Again, you will be asked for the dba_user database password. At the
MySQL prompt, enter following command:

GRANT ALL PRIVILEGES ON drupal.*
TO nobody@localhost IDENTIFIED BY 'password';

where

'drupal' is the name of your database
'nobody@localhost' is the userid of your webserver MySQL account
'password' is the password required to log in as the MySQL user

If successful, MySQL will reply with

Query OK, 0 rows affected

to activate the new permissions you must enter the command

flush privileges;

and then enter '\q' to exit MySQL.

3. LOAD THE DRUPAL DATABASE SCHEME

Once you have a database, you must load the required tables:

$ mysql -u nobody -p drupal < database/database.mysql

I just don't get that. Also im doing this for a school. Any help would be appreciated.

Comments

Chris Green’s picture

Which particular point are you stuck on?

What platform are you using (Windows/Linux/Mac OS X?)

Do you have mysql installed on your server?

Chris.

harishkm’s picture

the info u have given is not sufficient
provide more info...where u are stuck...
any errors...and what have u installed and versions of mysql,php etc..

cheers

joseph’s picture

Kamb, steps 2,3,4 etc. are all unix/linux/shell commands for setting up mysql database for Drupal. If you have mySQL installed in your server/host but don't have shell access you can still set up a Drupal database using the phpMyAdmin interface and edit the file conf.php to indicate the user/password/database/server names and be on your way.

But, from the looks of it, it seems that you are running sehs.us from a windows 2000 server. Do you have Php and mySql installed? If not, you at least need Php for Drupal to run. The database can be mySQL and others as well. The files you uploaded came with schema for mySQL, PostgreSQL and MSSQL. Check to see that you have all those. If you have php and some other SQL server then just use its interface to create a database and then import the appropriate database schema from the three files provided in the database folder.

On a side note, posting some pix of the award winning cheerleaders might motivate others on this board to help you set up the site post-haste.

kamb’s picture

ok, so i go into the config file and edit the myswl info. Ok I think I got it, i'll most likely be back. Though I have to wait tommorrrow to get MySQL info.

Also one more question. How much can the layout of the website using this technology be changed? I would love to keep the basic layout of my site (since it is a sub-site of a main site). www.sehs.us

kamb’s picture

am i doing this right?

this is in the config.php file.
# $db_url = "mysql://kris.brown1:*****@mysql.uplinkearth.com/M5464_forum";
# $db_url = "pgsql://user:password@hostname/database";
# $db_url = "mssql://user:password@hostname/database";
$db_url = "mysql://kris.brown1:*****@mysql.uplinkearth.com/M5464_forum";

This is what my host gave me:
The server is: mysql.uplinkearth.com
Database Name: M5464_forum
DSN Name: M5464_forum
Username: kris_brown1
Password: The password you signed up with

Chris Green’s picture

Looks OK to me (comparing to my conf.php file)

But I'm no expert. How did you get on?

Chris.

yasha’s picture

ok so if using phpmyadmin to set up them mysql database on a linux host, what do we do when we get to this step:

3. LOAD THE DRUPAL DATABASE SCHEME

Once you have a database, you must load the required tables:

$ mysql -u nobody -p drupal < database/database.mysql

...the part that isnt clear to me is how to load the required tables. is there something i can do inside phpmyadmin to do that, or is it something that has to happen outside of it?

i see the databse.mysql file, but dont know what to do with it.

ps.: on the subject of installation in general, it would be very nice if the main documentation was expanded to include what seems to be a very common method of install. showing step by step how to install drupal with ftp and phpmyadmin would be a very appreciated addition to the drupal community. i know there are countless varieties of install methods, but this would seem to me to be a very prominent one.

yasha’s picture

i found somewhat clearer help here:

http://deanspace.org/book/view/1006