How to extract a table content from mysql db backup file

Extract one table from mysql backup

Use this :--

zcat mythconverg.sql.gz | grep "INSERT INTO \`channel\` VALUES" > channel-table.sql

channel- table name.

No comments:

Post a Comment