Database Help

Help
Brad
2002-05-08
2002-05-18
  • Brad
    Brad
    2002-05-08

    Ok, for starters, this should just be a simple question, hopefully. :)

    In the instructions for install, it says to create a database specifially for Program E.  Ok, did that. Then it says to use a table layout(something like that) similar to db.sql.  Ok, question is, how?? The instructions jump to something else about the install and I'm stuck... I have a database with no tables.  I'm not the best at MySQL, so is there an easy way to do this??

    Thanks!

     
    • If you have phpmyadmin or someting of the like, paste db.sql's contents into the "run query" secrtion of the programe database.

       
    • Dave Hodgson
      Dave Hodgson
      2002-05-18

      Brad,
      If you have access to the commandline you can change to the sql/mysql directory where you installed E and type:

      mysql -D <i>DBname</i> -u <i>dbuseraccountname</i> -p < db.sql

      After you have entered your dbuseraccountname password this will run all the relevant SQL to create the tables. This assumes you have an account created with permissions on the DB and mysql is accessable through the path.

       
      • Dave Hodgson
        Dave Hodgson
        2002-05-18

        OOps please ignore <i> and </i> in above I should have seen that HTML appears as text, sorry for any confusion.