Desktop Database Editor

Discussion in 'MySQL' started by gobbly2100, Jul 6, 2007.

0
  1. #1
    Hey,

    I need to edit a MySQL file before I upload it to my new host but it is 20MB and anything I try to open it with takes forever.

    I could do with something that is supposed to be made for this kind of thing.

    All I want to change is a couple of lines to adjust the location of things.

    Any suggestions?
     
    gobbly2100, Jul 6, 2007 IP
  2. convertor

    convertor Peon

    Messages:
    34
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    If it's a mysql dump simply use notepad, if it's directly database file (frm) there is no way to edit it.
     
    convertor, Jul 6, 2007 IP
  3. gobbly2100

    gobbly2100 Banned

    Messages:
    906
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Ok that is strange, if I open it in Notepad it takes a good while but in Wordpad it is pretty instant.

    I would have thought Wordpad is more complex than Notepad, what is that about?

    It is a shame there is no actual editor but obviously there is no demand for it if there is no such thing.
     
    gobbly2100, Jul 6, 2007 IP
  4. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #4
    normally you would have mysql installed and then there are lots of editors that can connect to the server and make changes.
     
    AstarothSolutions, Jul 6, 2007 IP
  5. aceeca

    aceeca Well-Known Member

    Messages:
    663
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    133
    #5
    I would always suggest vi or emacs for this purpose.

    --Ace
     
    aceeca, Jul 7, 2007 IP