In the section Installing Drupal on Windows of the documentation, there's the following instruction:
Type the following dos-command: mysql -u username -ppassword drupal < c:...drupal\database\database.mysql (replace the appropriate parts, username, password, c:..., with the correct values. c:... must be the location of your Drupal folder).
Basically I find two problems with this. 1) Since I´m a newbie it´s not easy to spot possible mistakes in the instructions and, as a rule, I put into practice what I´m told LITERALLY. However I don´t manage to get this command work. I get the message "The system cannot find the specified file". I´ve tried different locations for the Drupal folder (as I haven´t clearly understand either "After downloading the Drupal package, start by extracting the archive to the PHP working folder (The folder that you specified for your documents in the php.ini file)") and I´m showing them in CAPITALS in the path. Well, so i´ve tried:
mysql -u username - password drupal < c:archivos de sistema\easyphp1-7\APACHE\drupal-4.3.0\database\database.mysql
mysql -u username - password drupal < c:archivos de sistema\easyphp1-7\WWW\drupal-4.3.0\database\database.mysql
mysql -u username - password drupal < c:archivos de sistema\easyphp1-7\PHP\drupal-4.3.0\database\database.mysql
mysql -u username - password drupal < c:archivos de sistema\easyphp1-7\drupal-4.3.0\database\database.mysql
I´ve also tried typing "-p password" (separated by a space) and "C:\Archivos..." instead of "-ppassword" and "C:Archivos..." as that way looks more familiar to me, but as I said, I can´t know whether there's a mistake or not.
AND... NONE OF THIS WORKS :(
Maybe I'm supposed not to have this problem. Shame on me, then, but all the same I´d be very grateful if someone could help me out. Best wishes to all
Comments
;
something else i´ve forgotten: am i supposed to type ; after the command?
nope
only if you're exec'ing commands from within mysql -- you're simply passing an argument to mysql in this instance, so no termination character is necessary.
try this
where username is your mysql username, for instance "root", and password the password of this user. note the quotes (") around "c:\archivos de sistema\easyphp1-7\drupal-4.3.0\database\database.mysql" - this is necessary if the path contains spaces (you better don't use spaces in path names anyway - you see the problems.)
the "Installing Drupal on Windows" documentation you mention was buggy and not maintained, so i just removed (emptied) it.
quotes + spaces + easyphp folder
thank you so much ax
some quick replies before i try your suggestion:
1. i´m afraid i´m forced to use spaces as the directory is called "archivos de programa" (spanish for "program files") and as far as i know i can't change that. but OF COURSE i should use quotes, dumb me, i KNEW that but it didn´t come to my mind this time (the documentation didn´t remind me either ;))
2. i assumed you´re correct in using no spaces between -u and username and between -p and password, although i usually use spaces there
3. i assumed from your reply (where you put nothing between easyphp1-7 and drupal-4.3.0) that the right folder to extract the drupal folder to is actually easyphp1-7 and not one of its subfolders
AND... IT WORKED!! :D
4. regarding buggy documentation, see my comment on http://drupal.org/node/view/999
thanks again for your quick reply