Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By dhar on
I recently installed Drupal but I am curious. I typed,
"mysql -u root -p drupaldb < C:/webdocs/drupal-4.7.4/database/database.4.1.mysql"
in the installation process (username - root, database - drupaldb). This did not execute. I assume more input was expected, that is, the result was the display of -> on the following lines. Why is this ?? I am still able to get the introductory page.
The products used are (1) Drupal 4.7.4 (2) PHP 5.1.6 (3) MySQL 5.0 (4) Apache 2.0.55
Comments
That command does nothing
That command does nothing but open a session to mysql - it doesn't actually perform any action on the data or on the site. Was there more to the command? There are a few things you need to do with mysql on a new site - create a database, load the table structure in and grant rights to the user you want the site to use (set in the site/default/settings.php file).
I think I understand...
Previously, I created the database (drupaldb) and granted rights to the user. The purpose of the command I used was to load the database. However, this was to be executed while not logged on to MySQL (supposed to have quit). I exited MySQL and executed the command. It worked. However, previously, I successfully executed it using MySQL Query Browser. As a result, I received appropriate error messages while attempting to execute it AGAIN in command-line !!! Do you agree with this reasoning ??....I'm new to Drupal/open-source techs. just learning... thanks.
You only need to create the
You only need to create the database structure once, and that can be done many different ways. So if you try to create the same table structure two different ways, than yes, you may get errors.