Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
VERY large text files and Snow Leopard
Open massive file on Mac?

I have a 16GB sql database backup I have just taken, what software can I open it with for Mac?

I have tried TextMate, but that just fails completely by just opening a blank page and not attempting to open it. Any software will do (raw text/UI).

share|improve this question

marked as duplicate by Nifle, Indrek, Ƭᴇcʜιᴇ007, ChrisF, Randolph West Oct 17 '12 at 20:31

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Assuming the SQL file was not created on that Mac, and depending on what you want to do with its data: just install the database software on that Mac, and import it into that new database?

share|improve this answer

There's a Vim plugin that allows it to open large files.

Then you could either go with the CLI version already installed or use MacVim.

share|improve this answer

How about:

less file.sql

from a terminal window? You can also use grep, etc.

share|improve this answer

HexFiend is the best application I've found for extremely large files as it does not try to store the entire file in memory. While more of a hex editor than a text editor it may be more than workable given that it works very, very quickly.

share|improve this answer

BBEdit can probably handle it (so should TextWrangler), but unless you really need to get inside and make some changes to the data, re-importing into the proper database management software is going to be your best bet.

share|improve this answer
In my experience TextWrangler (free) can handle large files much better than TextMate, but I haven't opened anything like 16GB with it. – donut Nov 16 '09 at 2:40

Terminal -> 'vi'

share|improve this answer