Restore single MySQL table from a full database mysqldump backup file
From DevOps Notebook
# sed -n -e '/DROP TABLE.*`mytable`/,/UNLOCK TABLES/p' mydatabase.sql > mytable.sql # mysql -u <user> -p mydatabase < mytable.sql
# sed -n -e '/DROP TABLE.*`mytable`/,/UNLOCK TABLES/p' mydatabase.sql > mytable.sql # mysql -u <user> -p mydatabase < mytable.sql