I've just had a major error on a server with a massive 6gig database. Now, I managed to restore nearly everything fine, but there are a couple of tables that are lost in this database file. I need a way from the console to extract tables from the dump file into a smaller dump file that i can then import through mysql. The problem is I cannot import the entire database as it will possibly overwrite some things that have happened after the database was taken.
Anybody know how to work with such large sql dumps?
