Big .Sql file, what program to edit?

Discussion in 'Databases' started by persons, Feb 7, 2011.

  1. #1
    hi i've been using myphp from cpanel to edit my database and to say a huge chunk is missing from server crash but i've backed it up in a 3 gig file. What i am trying to do is find a program to open the ".sql" which is saved on my computer so that i could use to edit certain parts to replace back into my server. The problem is i don't how what a good program is.. ive tried many but they require i connect to a database or is too large to open and i dont know how to edit .sql except through a GUI from myphp. Anyone know a good app? thanks =)
     
    persons, Feb 7, 2011 IP
  2. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #2
    If you have 4GB RAM in your system, then try opening it with EditPlus OR Notepad++.

    If the changes are such that you can do it after importing the data in MySQL, then that would be preferred way to apply changes because when 3GB file gets edited and saved, it will consume more memory for saving all the changes.
     
    mastermunj, Feb 7, 2011 IP
  3. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #3
    A "SQL" file is simply a text file. You can use any text editor to open and change the content.
     
    AstarothSolutions, Feb 8, 2011 IP
  4. techbrij

    techbrij Peon

    Messages:
    51
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    techbrij, Feb 9, 2011 IP
  5. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #5
    I also recommend notepad++. With that size file, you may have a very hard time editing it. If the data is not compressible it will take a lot of time to do anything within the file.
     
    jestep, Feb 10, 2011 IP
  6. jkl6

    jkl6 Peon

    Messages:
    70
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    jkl6, Feb 11, 2011 IP
  7. clonepal

    clonepal Active Member

    Messages:
    128
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    73
    #7
    You can split the files, use GSplit.

    -Alex
     
    clonepal, Feb 13, 2011 IP