==== 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;