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.

Programs that read MySQL

Discussion in 'MySQL' started by v4vikaskatoch, Feb 28, 2011.

0
  1. #1
    Hi, I always backup MySQL to my PC, what program do I use to read the SQL file? Yes I know of Notpad, but that's all imcrpted, and Wordpad works just fine, but when I do CTRL A CTRL F it crashes.

    So is there a SQL program out there that reads SQL files correctly?

    Thank you.
     
    v4vikaskatoch, Feb 28, 2011 IP
  2. chandan123

    chandan123 Prominent Member

    Messages:
    11,586
    Likes Received:
    578
    Best Answers:
    0
    Trophy Points:
    360
    #2
    sql files are just plain text files and you need any text editor to open that and all editors reads sql files correctly if they are within those editor's memory limits.
     
    chandan123, Feb 28, 2011 IP
  3. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #3
    As already said, they are plain text so any plain text editor can open and read the file, subject to its size. There are applications like Notepad++ that will colour code scripts like SQL to make them easier to read but they ultimately are just text editors too
     
    AstarothSolutions, Feb 28, 2011 IP
  4. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #4
    Notepad++ work great.
     
    jestep, Mar 1, 2011 IP
  5. phprocker

    phprocker Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Better use any free editor like Editplus. You can even notice the key terms of the mysql and this will let you know if any external crashes. Its free only.
     
    phprocker, Mar 1, 2011 IP
  6. carleisenstein

    carleisenstein Peon

    Messages:
    253
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #6
    You could always put MySQL on your PC and import it? Then you can query it in the way it was intended?

    But for text editing I like Notepad++ on Windows, TextWrangler on Mac and gEdit on Linux - all of them are free and can cope with pretty large files.
     
    carleisenstein, Mar 1, 2011 IP