Editor for large SQL text file

Can anyone recommend a good editor to chunk up or even open a large SQL text file?

The file is 230MB+ in size, I try in Wordpad and things really slow down ... lol!

I'm trying to import the file in to a mysql db, but it balks at record 40,000 or something ... wanting to chunk it up and do 5000 records at a time or something like that!

Greatly appreciated!

 

ultraedit is strongly recommended... their site: http://www.ultraedit.com/

or you can download it from most of the major download sites - e.g. tucows...

 

Real men use vim.

 

I agree with ultraedit. I've opened files larger than a few gigabytes. Trial version is full featured, with no spam other than a nag screen on startup. It's well worth a purchase, but just to open this file, the trial will do the job for you.

 

You can also handle it using Editplus, editplus.com

 

TextPad works perfect as well. I use both Textpad and Ultraedit. There are things that Ultraedit can do and Textpad can;t and things that Textpad can do but Ultraedit can;t.

 

Sometime they use awk too.

 

I believe www.TextMaster.ca has a solution for you.
Regards,
Jake

 

is there an editor that will open a db partially? say the first 100,000 lines or so? i have a db thats 350MB plus but its so large i cannot open it.

 

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

 

textpad also should be ok ... or emacs

 

Sini:
its on a windows server and its 750MB sql file. i have downloaded it and i would ike to get into it. is there something that will open it on my desktop like that? in pieces? i don't have enough memory and i would like to be able to do something with this file.

 

I suggest Metapad, www.liquidninja.com/metapad

 

You could use for example this one...it seems to be popular and easy to use. I haven't tested it though as I haven't been using windows for any administration like this in ages: http://www.soft32.com/download_186703.html

 

thanks much, that worked nicely to show me they set me up with the wrong database, geez, 750MB download and its the wrong damn one...lmao

that File Splitter divided it up into easy to manage sizes and here i'm looking at a pbpbb database when its supposed to be SMF.

thanks again for the link. for you.

 

I use Notepad++ is very good and it's open all files you need, you can download from here: http://softneo.com/notepad

 

Again, Vim

 

First, avoid Windows , and turn on to Linux / BSD.

Then, you have Geany : http://www.geany.org/ (very amazing).

 

notepad++

http://www.webexus.com

 

Just edited an 80mb SQL file with Ultraedit and it worked great, was super quick. thanks