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?
I'd import the database backup into a clean database and then dump just the tables you want to recover into the live database. Alternatively you could try and manually cut the section of the dump file, but I know what's the easier option.
cat dbdump.sql | grep "INSERT INTO tablename" > part.sql ??
Jacob - WebOnce Technologies - 30 Day 100% Satisfaction Guarantee - Over 5 Years Going Strong! Website Hosting, PHP4&5, RoR, MySQL 5.0, Reseller Hosting, Development, and Designs