How can i edit a 600 mb mysql database?

Discussion in 'MySQL' started by dumaniac, Sep 22, 2007.

0
  1. #1
    Which text editor do you suggest?I tried some but my windows crashes when i try to use them..
     
    dumaniac, Sep 22, 2007 IP
  2. SFOD_D223

    SFOD_D223 Peon

    Messages:
    4,512
    Likes Received:
    174
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You have to first dload from your server a s a text file. Then manually alter your info that you are looking to work on and then simply upload back as a text file. Making sure that you don't alter Category base after you have worked on it.

    BTW, I was able to edit mine with Notepad. I think it may have to do with your SQL updates.
     
    SFOD_D223, Sep 22, 2007 IP
  3. dumaniac

    dumaniac Well-Known Member

    Messages:
    398
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    110
    #3
    I have already downloaded it.My problem is editing.I tried notepad,notepad++ and Textpad but my windows keeps crashing.I'm looking for more powerful editors..
     
    dumaniac, Sep 22, 2007 IP
  4. simon369

    simon369 Active Member

    Messages:
    1,712
    Likes Received:
    47
    Best Answers:
    0
    Trophy Points:
    90
    #4
    notepad is probably best as other ones will take up more resources

    Try copying a bit at a time then work on that bit#

    IF that makes sense
     
    simon369, Sep 22, 2007 IP
  5. 007c

    007c Peon

    Messages:
    611
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Notepad wont handle that and will crash can't even do over 3 megs if i recall right. Get jujuedit works like a charm for me.
     
    007c, Sep 22, 2007 IP
    dumaniac likes this.
  6. dumaniac

    dumaniac Well-Known Member

    Messages:
    398
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    110
    #6
    Thank you very very much.It's what I was looking for.repped you :D
     
    dumaniac, Sep 22, 2007 IP