How to run queries

Discussion in 'MySQL' started by web-rover, Nov 27, 2005.

  1. #1
    Setting up an amazon store, and part of the set up asks to

    Run the queries in amazon.sql

    what does that mean, and how do it do it?

    thanks guys
     
    web-rover, Nov 27, 2005 IP
  2. kniveswood

    kniveswood Well-Known Member

    Messages:
    764
    Likes Received:
    29
    Best Answers:
    0
    Trophy Points:
    120
    #2
    Using cPanel?
     
    kniveswood, Nov 27, 2005 IP
  3. web-rover

    web-rover Peon

    Messages:
    1,341
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    0
    #3
    sorry, yeah cpanel
     
    web-rover, Nov 27, 2005 IP
  4. kniveswood

    kniveswood Well-Known Member

    Messages:
    764
    Likes Received:
    29
    Best Answers:
    0
    Trophy Points:
    120
    #4
    MySQL Databases > phpMyAdmin(bottom) > Choose database > SQL > Browse to your .sql file

    Do backup your database first. :D
     
    kniveswood, Nov 27, 2005 IP
    web-rover likes this.
  5. disgust

    disgust Guest

    Messages:
    2,417
    Likes Received:
    133
    Best Answers:
    0
    Trophy Points:
    0
    #5
    open phpmyadmin, setup a database (or select an existing one). then click on sql once the db is selected, and upload the text file

    you can also do it with shell access, but I'm guessing the above would be easiest for you.
     
    disgust, Nov 27, 2005 IP
    web-rover likes this.
  6. Liminal

    Liminal Peon

    Messages:
    1,279
    Likes Received:
    63
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Basically, in case you are still not clear, amazon.sql is a text file that contains a bunch of sql statements which they want you to execute against your database. Above are the steps to do so
     
    Liminal, Nov 28, 2005 IP
    web-rover likes this.
  7. web-rover

    web-rover Peon

    Messages:
    1,341
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    0
    #7
    thanks a bunch guys

    some green rep for you all.
     
    web-rover, Nov 28, 2005 IP