#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    7
    Rep Power
    0

    Help with running an SQL program


    Hi,

    Firstly please excuse my ignorance, this is my first time dealing with SQL.

    I needed to source a way to track warranties within my company, and found "warranty track" a SQL program. I have downloaded My SQL 5.6 and all the works with it.

    But for the life of me i cant work out how to get the .sql file to a state where i can run it.

    The readme file included on the initial download states...

    "Steps to install the system.


    1. Create the DB on your MySQL Server. Eg: dbWTRacker

    2. Extract the file dbWTRackerOS.sql.zip and paste the sql text in it, onto your SQL window on PHPMyAdmin.
    Alternatively, you can import the file using the interface on PHPMyAdmin.

    3. Extract the file wtos-code.zip to your desired web/localhost folder."

    Can anyone help me?

    Many Thanks

    Callum Irvine
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by callumirvine
    But for the life of me i cant work out how to get the .sql file to a state where i can run it.
    did you understand the part about extracting the .sql file from the zip?

    how about the part where you paste the text of the sql file into phpmyadmin?

    p.s. i've moved your thread from the microsoft sql server forum to the mysql forum
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    7
    Rep Power
    0
    Hi Thanks for the reply,

    Yes i have extracted the Sql file so i now have filename.sql

    I downlaoded myphpadmin but i have no idea how to run it as it is just hundreds of php files?

    P.S
    Thanks for moving it to the correct place!
  6. #4
  7. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    sorry, can't help you with phpmyadmin, i use heidisql, it's only one file, an executable
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    7
    Rep Power
    0
    Should i download that then?

    and when it states, paste the text from the .sql, how do i get the text from the file?
  10. #6
  11. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by callumirvine
    Should i download that then?
    that would be entirely up to you, but all i can say is that i much prefer heidisql over phpmyadmin

    Originally Posted by callumirvine
    and when it states, paste the text from the .sql, how do i get the text from the file?
    open the sql file in a text editor

    hopefully you have a text editor a bit more comprehensive than notepad, but if not, may i recommend ultraedit
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  12. #7
  13. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    7
    Rep Power
    0
    Okay both are downloaded,

    As I previously stated, please excuse my ignorance, With HeidiSQL is there a setup procedure? As it is requesting a server, port and credentials to set up a session?
  14. #8
  15. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by callumirvine
    As it is requesting a server, port and credentials to set up a session?
    you would need this for any front-end program that wants to access your mysql server

    here's a screenshot of my heidisql
    Attached Images
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  16. #9
  17. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    7
    Rep Power
    0
    Thats the same as mine, except i don't have a password,

    Where would i set/acquire this?
  18. #10
  19. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by callumirvine
    Thats the same as mine, except i don't have a password
    did you try leaving that field blank?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  20. #11
  21. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    7
    Rep Power
    0
    Originally Posted by r937
    did you try leaving that field blank?
    Yes, i also tried root, as i read somewhere that was the default.

    Neither work.
  22. #12
  23. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    you're gonna have to go ask whoever installed mysql what user/password they created
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  24. #13
  25. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    7
    Rep Power
    0
    Okay I've got it now, silly mistake they used a capital on "Root".

    I am now in HeidiSQL, I have the text from my SQL in ultraedit.

    where do i paste this?
  26. #14
  27. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by callumirvine
    where do i paste this?
    in a new query window
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo