|
1 2 3 4 5 6 7 8 9 10 11 12 |
>> 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#