Can I restore a single table from a full mysql mysqldump file?

Posted by Mobius on Stack Overflow See other posts from Stack Overflow or by Mobius
Published on 2009-06-18T16:50:32Z Indexed on 2010/04/14 11:13 UTC
Read the original article Hit count: 151

Filed under:
|
|
|

I have a mysqldump backup of my mysql database consisting of all of our tables which is about 440 megs. I want to restore the contents of just one of the tables form the mysqldump. Is this possible? Theoretically, I could just cut out the section that rebuilds the table I want but I don't even know how to effectively edit a text document that size.

© Stack Overflow or respective owner

Related posts about mysqldump

Related posts about mysql