Hi !

I have a sql file around 200 MB... and i want to open it?

im trying with all text editor but is imposible to open!

some one now a way to open that file

thank you

In my memory, it's a real pain.

Last time I had to do so on a 1.5 Go file, I've created an PHP script to do it for me, reading the file line after line, and creating a new file with just the modified lines.

Otherwise, try to use an Hex editor.
As far as I know, the load only a small part of the file in memory.
But, the cannot expand a file, ie: you can only replace characters, not add them.

Or, the last solution, and maybe the easiest:
Import your sql file in a temporary database, make the modifications you need on the datas, and dump the temporary database again.

ok ... i understand

i was thinking that was some slq studio soft for this big files.

thank's

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

Hoooo, I never knew about that one...

Thanks a lot, it will totally help me in any future case like that.