Restore 1 table from a Database dump


You may sometimes need to restore just one table from a database dump in another database, this will do the job pretty well in standard cases.

sed -n -e '/CREATE TABLE.*`table_users`/,/CREATE TABLE/p' thedbdumpfile.sql | tr '\n' ' ' 2>&1 | grep -oP '.*UNLOCK TABLES;