Announcement

Collapse
No announcement yet.

Extract one table from mysql backup

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Extract one table from mysql backup

    Use the following command line to extract a table from mysql backup.

    # zcat mythconverg.sql.gz | grep "INSERT INTO \`channel\` VALUES" > channel-table.sql
    Where "mythconverg.sql.gz" --- Backup file.
    "channel" --- Table name
    Warm Regards,
    Keanu
    Support Team
Working...
X