By kevinlebo on

Hi all! Sorry to be such the n00b, but I've never worked with any database program before, including MySQL, and I'm having a bit of trouble at Step 3 of the Installation guide, "LOAD THE DRUPAL DATABASE SCHEME." The documentation says, "Once you have a database, you must load the required tables:
$ mysql -u nobody -p drupal < database/database.mysql"

Using the user account I created in MySQL as the user, as opposed to nobody, when I enter this command I get the following message: "-bash: database/database.mysql: No such file or directory" I figured database was a generic term for the database I created, but when I substituted drupal for databse it still didn't take. To the best of my knowledge I've completed the previous steps of the guide correctly. If it helps, I'm using MySQL version 3.23.54, php 4.2.2, and Linux kernal 2.4.20-6 running on RedHat 9.0. Any help would be apprieciated! Thanks!

Comments

kevinlebo’s picture

kevinlebo commented

I think I figured the first part out actually; however now I have a new issue along the same lines. I lined the database up properly to connect Drupal to it, but now I get the message:

ERROR 1064 at line 1: You have an error in your SQL syntax near '?php
// $Id: database.mysql.inc,v 1.16 2003/05/07 21:00:36 dries Exp $
function' at line 1

Any clues?

marky’s picture

marky commented

the file you're supposed to load into MySQL is /database/database.mysql. If you examine this file (it's just plain text) you'll see it contains lots of 'create table ...' commands.

It does what it says ;o)

You're trying to load /includes/database.mysql.inc, which contains the routines Drupal uses internally to 'communicate' with the db.

CIDER’s picture

CIDER commented

how do you get these tables created? /database/database.mysql

i dont have ssh access, i have created the db in mysql and have configured the config file accordingly, i just need to know how to get the tables inserted

kbahey’s picture

kbahey commented

Should be available in your hosting account.
Or download it from here http://www.phpmyadmin.net/home_page, and install it.
It Not that difficult.

It allows you to do what you would normally do from ssh (database commands)

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba

CIDER’s picture

CIDER commented

as stated in the other thread, i have phpmyadmin on my webserver however i dnt know how to instal the table schema.

kbahey’s picture

kbahey commented

Just open phpmyadmin, then select the database you want (or create a new one if you have permissions).
Then open the database.mysql file in an editor, and copy and paste everything in it to a SQL window, and press "Go".

Alternatively, you could select "Browse" and point it to the same file.

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba

CIDER’s picture

CIDER commented

thank you kbahey that worked perfect

matheney’s picture

matheney commented

I'm trying to install drupal on a web host, that has the user's mySQL database on another server (other than localhost). I am used to loading the tables via the cpanel, but this host is different. In addition, loading it using the instructions in the INSTALL file is no good.

Is there anyway I can load it in via web interface? Other than FTP, and web, there are no other tools for me to be able to create the database scheme. :(

Any tips?

Thanks

matheney’s picture

matheney commented

Nevermind...found it. All one needs to do is to insert the host :)

shell> mysql -h host -u user -p
Enter password: ********
kevinlebo’s picture

kevinlebo commented

*****Edited - nevermind - I found it! Thanks a bunch for the help!****

That was my original problem though. I cannot find the database/database.myspl file anywhere. Would you know where it is located by default?