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.
  2. Better Analytics for WordPress Get It Free

Editor for large SQL text file

Discussion in 'MySQL' started by anton-io!, Sep 21, 2005.

  1. #1
    Can anyone recommend a good editor to chunk up or even open a large SQL text file?

    The file is 230MB+ in size, I try in Wordpad and things really slow down ... lol! :eek:

    I'm trying to import the file in to a mysql db, but it balks at record 40,000 or something ... wanting to chunk it up and do 5000 records at a time or something like that!

    Greatly appreciated!
     
    anton-io!, Sep 21, 2005 IP
  2. daboss

    daboss Guest

    Messages:
    2,251
    Likes Received:
    151
    Best Answers:
    0
    Trophy Points:
    0
    #2
    ultraedit is strongly recommended... their site: http://www.ultraedit.com/

    or you can download it from most of the major download sites - e.g. tucows...
     
    daboss, Sep 21, 2005 IP
  3. forkqueue

    forkqueue Guest

    Messages:
    401
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    0
    #3
    forkqueue, Sep 21, 2005 IP
  4. nevetS

    nevetS Evolving Dragon

    Messages:
    2,544
    Likes Received:
    211
    Best Answers:
    0
    Trophy Points:
    135
    #4
    I agree with ultraedit. I've opened files larger than a few gigabytes. Trial version is full featured, with no spam other than a nag screen on startup. It's well worth a purchase, but just to open this file, the trial will do the job for you.
     
    nevetS, Sep 21, 2005 IP
  5. Skeleton

    Skeleton Peon

    Messages:
    116
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #5
    You can also handle it using Editplus, editplus.com
     
    Skeleton, Sep 21, 2005 IP
  6. honey

    honey Prominent Member

    Messages:
    15,556
    Likes Received:
    712
    Best Answers:
    0
    Trophy Points:
    325
    #6
    TextPad works perfect as well. I use both Textpad and Ultraedit. There are things that Ultraedit can do and Textpad can;t and things that Textpad can do but Ultraedit can;t.
     
    honey, Sep 22, 2005 IP
  7. johnt

    johnt Peon

    Messages:
    178
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    0
    #7
    johnt, Sep 22, 2005 IP
  8. zsikic

    zsikic Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    I believe www.TextMaster.ca has a solution for you.
    Regards,
    Jake
     
    zsikic, Feb 21, 2007 IP
  9. sawz

    sawz Prominent Member

    Messages:
    8,230
    Likes Received:
    807
    Best Answers:
    0
    Trophy Points:
    310
    #9
    is there an editor that will open a db partially? say the first 100,000 lines or so? i have a db thats 350MB plus but its so large i cannot open it.
     
    sawz, Feb 26, 2007 IP
  10. Sini

    Sini Peon

    Messages:
    119
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #10
    With linux shell (over ssh for example) you can easilly chop it in pieces with for example following command:

    Lets assume your sql file is example.sql. With this command the sql file will be choped to 50m pieces. CD to the directory where the sql file is located and execute following command:

    split -b 50m example.sql example_

    You will get files example_aa , example_ab and so on.

    now you can open any of those files, edit and save. When you are done you can combine those files with a command like for example:

    cat example_[aa-bb] > example.sql
     
    Sini, Feb 26, 2007 IP
  11. commandos

    commandos Notable Member

    Messages:
    3,651
    Likes Received:
    329
    Best Answers:
    0
    Trophy Points:
    230
    #11
    textpad also should be ok ... or emacs :D
     
    commandos, Feb 26, 2007 IP
  12. sawz

    sawz Prominent Member

    Messages:
    8,230
    Likes Received:
    807
    Best Answers:
    0
    Trophy Points:
    310
    #12
    Sini:
    its on a windows server and its 750MB sql file. i have downloaded it and i would ike to get into it. is there something that will open it on my desktop like that? in pieces? i don't have enough memory and i would like to be able to do something with this file.
     
    sawz, Feb 27, 2007 IP
  13. Your Content

    Your Content Banned

    Messages:
    1,096
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    0
    #13
    Your Content, Feb 27, 2007 IP
  14. Sini

    Sini Peon

    Messages:
    119
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #14
    You could use for example this one...it seems to be popular and easy to use. I haven't tested it though as I haven't been using windows for any administration like this in ages: http://www.soft32.com/download_186703.html
     
    Sini, Feb 27, 2007 IP
    sawz likes this.
  15. sawz

    sawz Prominent Member

    Messages:
    8,230
    Likes Received:
    807
    Best Answers:
    0
    Trophy Points:
    310
    #15
    thanks much, that worked nicely to show me they set me up with the wrong database, geez, 750MB download and its the wrong damn one...lmao

    that File Splitter divided it up into easy to manage sizes and here i'm looking at a pbpbb database when its supposed to be SMF.

    thanks again for the link. :D for you.
     
    sawz, Feb 27, 2007 IP
  16. ieronim

    ieronim Peon

    Messages:
    25
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #16
    ieronim, Mar 19, 2012 IP
  17. phapit

    phapit Peon

    Messages:
    26
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #17
    Again, Vim
     
    phapit, Mar 24, 2012 IP
  18. azmoum

    azmoum Member

    Messages:
    59
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    46
    #18
    First, avoid Windows , and turn on to Linux / BSD.

    Then, you have Geany : http://www.geany.org/ (very amazing).
     
    azmoum, Mar 24, 2012 IP
  19. guruwebmaster

    guruwebmaster Active Member

    Messages:
    147
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #19
    guruwebmaster, Apr 2, 2012 IP
  20. nickjag

    nickjag Active Member

    Messages:
    50
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    56
    #20
    Just edited an 80mb SQL file with Ultraedit and it worked great, was super quick. thanks
     
    nickjag, Mar 6, 2013 IP