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
correction
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.mysqlSorry! Forgot to add "code" markup so it did not display properly.
I'm having the exact same
I'm having the exact same problem...
Hmmm....have you found a
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\databaseBut, am I suppose to point to this in my path? aggg. how? help?
Cynthia (Sunni) Freyer
~~~ patience please: hand coder going drupal ~~
Just a quick FYI that I have
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/210406g7b4diI 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 ~~
Problem solved. For anyone
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 ~~
Thank you, problem solved
Thank you, problem solved for me as well. : )