Restore table mysql

gistfile1.txt

#!/bin/bash
# Restore table(table+data or only data) from mysqldump file
#
# NOTE: 'foo' is the table to restore and 'bar' next table in backup.

# Restore one table
zcat backup_20090316-0200.sql.gz | awk '/Table structure for table .foo./,/Table structure for table .bar./{print}' > output.sql

# Restore only data from one table 
zcat backup_20090316-0200.sql.gz | awk '/Dumping data for table .foo./,/Table structure for table .bar./{print}' > output.sql

# Find backup files in subdirectories and restore only data
find . -wholename './*/*gz' -print | xargs zcat | awk "/Dumping data for table .foo./,/Table structure for table .bar./{print}" >> foo_data.sql