https://wiki.twig.es/index.php?action=history&feed=atom&title=Selecting_a_table_from_a_mysqldump_file Selecting a table from a mysqldump file - Revision history 2026-05-06T13:18:57Z Revision history for this page on the wiki MediaWiki 1.23.0 https://wiki.twig.es/index.php?title=Selecting_a_table_from_a_mysqldump_file&diff=2073&oldid=prev George2: Created page with "sed -n -e '/DROP TABLE.*mytable/,/UNLOCK TABLES/p' mydump.sql > tabledump.sql <br> sed -n -e '/CREATE TABLE.*mytable/,/CREATE TABLE/p' mysql.dump > mytable.dump<br> Referenc..." 2015-06-10T15:43:58Z <p>Created page with &quot;sed -n -e &#039;/DROP TABLE.*mytable/,/UNLOCK TABLES/p&#039; mydump.sql &gt; tabledump.sql &lt;br&gt; sed -n -e &#039;/CREATE TABLE.*mytable/,/CREATE TABLE/p&#039; mysql.dump &gt; mytable.dump&lt;br&gt; Referenc...&quot;</p> <p><b>New page</b></p><div>sed -n -e '/DROP TABLE.*mytable/,/UNLOCK TABLES/p' mydump.sql &gt; tabledump.sql &lt;br&gt;<br /> <br /> sed -n -e '/CREATE TABLE.*mytable/,/CREATE TABLE/p' mysql.dump &gt; mytable.dump&lt;br&gt;<br /> <br /> Reference : http://stackoverflow.com/questions/1013852/can-i-restore-a-single-table-from-a-full-mysql-mysqldump-file</div> George2