Edit very large sql dump/text file (on linux)

Posted by geo on Stack Overflow See other posts from Stack Overflow or by geo
Published on 2009-03-31T02:19:49Z Indexed on 2010/03/19 19:11 UTC
Read the original article Hit count: 128

Filed under:
|
|

I have to import a large mysql dump (up to 10G). However the sql dump already predefined with a database structure with index definition. I want to speed up the db insert by removing the index and table definition.

That means I have to remove/edit the first few lines of a 10G text file. What is the most efficient way to do this on linux?

Programs that require loading the entire file into RAM will be an overkill to me.

© Stack Overflow or respective owner

Related posts about large-files

Related posts about linux