How to run a .sql file in phpMyAdmin

Discussion in 'Databases' started by drhfinegifts, Jul 13, 2006.

  1. #1
    I don't know much about the SQL side of my site, but need to run a .sql file in order to add a contribution to my osCommerce based site.

    Problem is that I don't have the first clue on how to do this.

    Can anyone help?

    Thanks!
     
    drhfinegifts, Jul 13, 2006 IP
  2. suzigeek

    suzigeek Peon

    Messages:
    142
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Get into phpmyadmin and select the database that your trying to modify. Select the sql tab and paste the sql query into the window. Hit go.

    Theres also a way to browse to a file and run it but I can't remember it at the moment.
     
    suzigeek, Jul 13, 2006 IP
  3. drhfinegifts

    drhfinegifts Peon

    Messages:
    368
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I figured it was probably something very simple, I just didn't know how to do it!

    Worked like a charm - thanks suzigeek!
     
    drhfinegifts, Jul 13, 2006 IP
  4. suzigeek

    suzigeek Peon

    Messages:
    142
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Yay! Glad I could help :)
     
    suzigeek, Jul 14, 2006 IP