1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How do I read/open an .sql file?

Discussion in 'Programming' started by dementic, Jan 14, 2008.

  1. #1
    I have an old database backup from my oscommerce store stored as an .sql file. I would like to browse through the contents but I unfortunately don't know what to do with an sql file.

    In terms of database programs, I own MS Access 2003.

    Any help is appreciated.
    SEMrush
     
    dementic, Jan 14, 2008 IP
    SEMrush
  2. mybluehair

    mybluehair Peon

    Messages:
    1,375
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    0
    #2
    an sql file is simply a text file. this file can be opened in any text editor (say maybe notepad, for instence)
     
    mybluehair, Jan 14, 2008 IP
  3. dementic

    dementic Peon

    Messages:
    280
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thank you for your fast reply,
    but i wish to browse its content, not just view text.
     
    dementic, Jan 14, 2008 IP
  4. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,681
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #4
    There is no "content" it is simply a text file as said above.

    What are you wanting to "see"?
     
    AstarothSolutions, Jan 14, 2008 IP
  5. dementic

    dementic Peon

    Messages:
    280
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #5
    like a database browser or something
     
    dementic, Jan 14, 2008 IP
  6. Dondon2d

    Dondon2d Peon

    Messages:
    3,193
    Likes Received:
    146
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Use phpmyadmin, then import the .sql file, and browse.
     
    Dondon2d, Jan 14, 2008 IP
  7. rkquest

    rkquest Active Member

    Messages:
    829
    Likes Received:
    22
    Best Answers:
    0
    Trophy Points:
    90
    #7
    everything the .sql file contains are commands.. so you won't be able to browse the tables unless you import it to a database server. What kind of database are we talking about anyway? do you have the database server installed in your computer?
     
    rkquest, Jan 14, 2008 IP
  8. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,681
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Either you will have to install the db server and then use a GUI interface for it to see it or alternatively there are a few bits of software that will do this as a stand alone without the need for the server.

    You will need to search for the relevant server/ software depending on if the commands are for mysql/ ms sql/ oracle etc
     
    AstarothSolutions, Jan 15, 2008 IP
  9. iwyrobi

    iwyrobi Peon

    Messages:
    91
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #9
    i think oscommerce use mysql. so as dondon say you need phpmyadmin or other gui that support mysql command.
    just execute (import) the sql file. then you can browse it
     
    iwyrobi, Jan 15, 2008 IP
  10. mojoool

    mojoool Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #10
    hi guys
    i had this problem too
    what u want is a wordpad or office or any kind of text_file editer
    just open .sql files with them and then u can see what is in it!!

    and another thins i sholud say:
    .sql format files can not open with notepad!!!!
     
    mojoool, Jul 2, 2012 IP
  11. extraspecial

    extraspecial Member

    Messages:
    788
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    45
    #11
    I recommend to use Notepad++ just google it, it opens anything :)
     
    extraspecial, Jul 8, 2012 IP
  12. fiveHellions

    fiveHellions Peon

    Messages:
    16
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #12
    SQLite Database Browser
     
    fiveHellions, Jul 10, 2012 IP