How can I view Backup Database data without restoring database

Discussion in 'MySQL' started by Darden12, Aug 12, 2009.

0
  1. #1
    I am trying to get some data out of a MYSQL database of mine from a couple of days ago. The problem is, the only way that I can access the data (at least through my host) is by restoring the old database -- but I don't want to restore the old database: I only want to get a little data from it (specifically, an article posted in a table called 'Article').

    Is there someway I can access the data in that database without rewriting my existing database?

    I have downloaded the backed up database as a .sql file, but now I don't know what to do with it.

    Thanks,

    Brian
     
    Darden12, Aug 12, 2009 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    If it's a sql file, you can open it in a text editor, and try to find the data you need. If this is a large database, it may be very difficult to get what you are looking for.

    You could always install mysql locally, and create the database on your local installation.
     
    jestep, Aug 12, 2009 IP
  3. morehawes

    morehawes Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Probably easiest. Look into XAMPP is you're unsure how to do this.
     
    morehawes, Sep 11, 2009 IP