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 would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
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.
OOps please ignore <i> and </i> in above I should have seen that HTML appears as text, sorry for any confusion.