Trouble with MySQL and Drupal!

 
Post new topic   Reply to topic    Aprelium Forum Index -> Databases
View previous topic :: View next topic  
Author Message
foti
-


Joined: 10 Jul 2006
Posts: 3

PostPosted: Wed Jul 12, 2006 1:07 pm    Post subject: Trouble with MySQL and Drupal! Reply with quote

The Drupal database schema will not load into MySQL!!
Having entered my password in the MySQL monitor cmd line, I enter:
Open quote:
mysql -u myusername -p drupal < database/database.4.1.mysql;
Close quote
as instructed, it just moves down to the next line showing:
Open quote:
->
Close quote.

The database hasn't loaded!
There is obviously something else I am supposed to do here, but I can't see what?
Reading all of the message boards and instructions isn't helping.

PLEASE HELP, I've been setting everything up for four days now and I have been stuck on this for two of them!
This is almost becoming painful.

This is what I'm using:
XP with:
Abyss Web Server X1,
Drupal-4.7.2,
MySQL Server 5.0
MySQL Administrator 1.1.9
and
Php4.4.2.

Thanks in advance. :cry:
Back to top View user's profile Send private message
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Thu Jul 13, 2006 3:05 pm    Post subject: Re: Trouble with MySQL and Drupal! Reply with quote

foti wrote:
mysql -u myusername -p drupal < database/database.4.1.mysql;


Try removing the ; at the end of the line and replace / with \. Does it work now?

If not, we suggest installing PhpMyAdmin and upload the mysql schema file from there. With PhpMyAdmin you have more explicit error messages (if any).
_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Send e-mail
foti
-


Joined: 10 Jul 2006
Posts: 3

PostPosted: Thu Jul 13, 2006 5:09 pm    Post subject: Thank you!!! Reply with quote

I'll try that now and get back to you.

Cheers, I'm going a bit mental here!
Back to top View user's profile Send private message
loloyd
-


Joined: 03 Mar 2006
Posts: 435
Location: Philippines

PostPosted: Sat Jul 15, 2006 10:58 am    Post subject: Reply with quote

hi, foti. i am an avid (ab)user of drupal+abyss.

that command is meant to be run at your OS's command prompt and not inside the mysql environment space. if you're using windows, open up a command prompt and add the location of your mysql executable to your PATH environment setting. usually it's at "C:\Program Files\MySQL\MySQL Server 4.1\bin". this makes mysql.exe available anywhere. then change directory to your drupal folder and issue that command in your command prompt, replacing "database/database.4.1.mysql" with "database\database.4.1.mysql" as aprelium has pointed out if you're using windows. don't forget to remove that semicolon ";" at the end.

i hope this helps. pm me if you need further assistance. i'm hoping to see more drupal+abyss users in here.
_________________

http://home.loloyd.com/ is online if the logo graphic at left is showing.
Back to top View user's profile Send private message Visit poster's website
foti
-


Joined: 10 Jul 2006
Posts: 3

PostPosted: Tue Jul 18, 2006 7:43 pm    Post subject: Hi guys Reply with quote

I've tried following the advice here (I ran it in XP's command prompt and in the one that comes as an option with MySQL administrator), but it's just one problem after another with this stuff.....

Thanks so much for all the help, but I've given up and uninstalled everything.

I've wasted two weeks during which I would have been better off teaching myself RSS, PHP, Javascripting and so on.

So, that's what I'm going to have to do now, since this is just WAY TOO USER-UNFRIENDLY for me!

Sorry, maybe I'll come back when I've regained the will to live.

Thanks for being so kind and patient, and best of luck to anyone who is new to this!

Bye.
Back to top View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Databases All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group