How to open / edit big .sql or other text files
With linux shell (over ssh for example) you can easilly chop big .sql or other text filesin 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