opening a database

Discussion in 'Databases' started by kanwarjot, Apr 17, 2007.

0
  1. #1
    Hello Masters
    i am facing a strange prob plz help me out...i recently got a database of lyrics which is more than 600MB..the basic problem is that due to such huge size i am not able to open it with notepad..
    could u plz let me know how can i open it up and edit it..
    Thanking all of u
    KJS
     
    kanwarjot, Apr 17, 2007 IP
  2. yourguides

    yourguides Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I use NoteTab Light for all my text documents and haven't had a problem.

    Just to be sure, though, with something that big, why not use MS Word?
     
    yourguides, Apr 17, 2007 IP
  3. venetsian

    venetsian Well-Known Member

    Messages:
    1,105
    Likes Received:
    61
    Best Answers:
    0
    Trophy Points:
    168
    #3
    Open it with WordPad .. works only with buffers so it won't matter the size .. I had this problems couple time so that was my solution ..

    Cheers,

    Venetsian.
     
    venetsian, Apr 17, 2007 IP
  4. Justin Nijs

    Justin Nijs Well-Known Member

    Messages:
    631
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    110
    #4
    Upload it in phpmyadmin (contact your hoster when the file is too big.)
    Edit it in phpmyadmin:
    -It wil be more synoptic.
    -More easy to edit.
    -Faster savings.
     
    Justin Nijs, Apr 17, 2007 IP
  5. Darkhodge

    Darkhodge Well-Known Member

    Messages:
    2,111
    Likes Received:
    76
    Best Answers:
    1
    Trophy Points:
    185
    #5
    Use "SQLDumpSplitter" to slip your 600MB dump into multiple 40~50MB ones. Then use these to upload the database bit by bit.

    PhpMyAdmin only allows you to import files of upto something like 50MB anyway so this is the best way in my opinion.

    Please enlighten me if there's a better way though :)
     
    Darkhodge, Apr 17, 2007 IP