sh
>> Extract single table from a running database
mysqldump dbname tableName > tableName.sql
>> Extract table from a MySQL dump:
> Option 1) Using 'sed'
sed -n "/^-- Table structure for table \`TABLE_NAME_HERE\`/,/^-- Table structure for table/p" DATABASEDUMP.SQL > TABLENAME-TABLE.sql
> Option 2) Using dbsake: https://github.com/abg/dbsake
cat file.sql | dbsake split-mysqldump -C /tmp/sql
>> Import the table:
# mysql -D dbname < tableName.sql
Sources: http://blog.tsheets.com/2008/tips-tricks/extract-a-single-table-from-a-mysqldump-file.html https://github.com/JoyceBabu/MySQL-Dump-Table-Extractor http://blog.tsheets.com/2008/tips-tricks/extract-a-single-table-from-a-mysqldump-file.html# https://github.com/abg/dbsake