Newbie here. Problem: Loading database -- how the heck do I solve?
--------------------

I installed Apache2Triad at Local Disk (C:) and confirmed that it was up and running as expected on my local desktop PC (XP SP3). I then installed Drupal-6.2 into htdocs of Apache installation. My next step was to create a database and populate it with the necessary tables and structures that Drupal need in order to function.

I opened up a command-line shell (Start/Run, cmd) I did the following:

1. C:\ mysqladmin -u root -p create drupal and entered password 123snuggles123 when prompted.

2. Entered the MySQL command-line prompt by using the command: C:\ mysql -u root -p Entered password 123snuggles123 again when prompted

3. Set database username and password for Drupal specifically by entering the command:

mysql>GRANT ALL PRIVILEGES ON drupal.* TO drupal@localhost IDENTIFIED BY '123snuggles123';

I rec'd the correct response from the command and the screen looked like this:

.................. Query OK, 0 rows affected <0.37 sec>
....................mysql>
4. I then typed: mysql> flush privileges;

5. Type quit to exit the MySQL command-line client and then went on to the next step, loading the database.

I am having a problem at this point with the path

The command is suppose to be:

mysql -u drupal -p drupal

I receive an error message saying that the path is incorrect. C:/apache2triad/htdocs/drupal-6.2 path is correct. But when I look inside the drupal-6.2 dir, I do not see a dir having the name: database.

I did some exploring via My Computer and found: C:\apache2triad\mysql\data\drupal

And at this point, I'm stumped.

Any ideas on what I do next? Confused in Washington state...

HUGE THANK YOU TO ANYBODY WHO CAN HELP!!

Sunni

Comments

nwsunni’s picture

My text reads: The command is suppose to be: mysql -u drupal -p drupal

That should read: mysql -u drupal -p drupal <C:/apache2triad/htdocs/drupal-6.2/database/database.4.1.mysql

Sorry! Forgot to add "code" markup so it did not display properly.

samwich’s picture

I'm having the exact same problem...

nwsunni’s picture

Hmmm....have you found a solution? Anybody have any ideas?

I did do a search simply for folder "database" within the C:/apache2triad directory and I found it in C:\apache2triad\htdocs\uebimiau\database

But, am I suppose to point to this in my path? aggg. how? help?

Cynthia (Sunni) Freyer
~~~ patience please: hand coder going drupal ~~

nwsunni’s picture

Just a quick FYI that I have emailed this question to David Mercer, author of the packt book that I am getting my instructions from: http://www.packtpub.com/drupal/book/mid/210406g7b4di

I am beginning to suspect that the problem is associated with the version of Drupal I am using -- the newest release versus the version he wrote about.

Doesn't solve the problem, though

Cynthia (Sunni) Freyer
~~~ patience please: hand coder going drupal ~~

nwsunni’s picture

Problem solved.

For anyone that needs to know the solution, David Mercer was kind enough to write me to say:

once you have created a database (using cmd screen in Windows), you can go directly to the Drupal installation. Drupal 6 will install all the tables you need automatically

Cynthia (Sunni) Freyer
~~~ patience please: hand coder going drupal ~~

samwich’s picture

Thank you, problem solved for me as well. : )