I have a large text file which is about 60gig in size. It's an SQL dump created by mysqldump.
I need to restore data from one of the tables. Restoring the whole file is not ideal.
My question is, how do I get just that segment of data out of the file?
I tried a ruby script which I found from googling around. But when I ran it, it just slowly ate up all of the memory and crashed the server.
Link to ruby script
I need to get everything between a line that says "CREATE TABLE `table_needed`" and "CREATE TABLE `next_table`
I think csplit would work, but I have no idea how to use it.
Any help appreciated.