User Tools

Site Tools


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;
docu/csheet/sysadm/db/my/restore_1table.txt · Last modified: 2020/03/04 10:05 by admin