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 =)
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.
I use Notepad++ for blogging and development. It has all basic features of editor. It is simple and fast. See 10+ Notepad++ Tips For Fast Development
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.
Try this Large Text File Viewer. It's built specifically for large text files. http://www.swiftgear.com/ltfviewer/features.html