Tips for opening up a massive SQL file

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Tips for opening up a massive SQL file

Post by m3mn0n »

I have an SQL file that's about 300 MB+ in size.

What would you do to open up such a file?

Notes:
-Dreamweaver out of the question... it's locks up at 5MB SQL files
-WordPad/Notepad out of the question... my computer (with 768 MB of DDR) crashes if trying to open it in these two programs
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

TextPad can open it.
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post by m3mn0n »

Right now I'm trying to split this baby up into 2 MB chunks via PHP, but I'll give that a go. :)
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post by m3mn0n »

/me is textpads newest fan :wink:

Thanks for the quick tip man!
Post Reply