Restoring a MySQL table back to the database
When we need to restore a single MySQL table from big data MySQL backup. Most modern text editors should be able to handle a text file that size, if your system is up to it. so you can use sed.
sed -n -e ‘/DROP TABLE.*table_name
/,/UNLOCK TABLES/p’ backupfile.sql > mytable.sql