Restore Single table from dump backup

Restore Single table from dump backup

Extract Table 

sed -n '/CREATE TABLE `entity_schemas`/,/UNLOCK TABLES;/p' dbbackup_full_20260219.2100.sql > entity_schemas.sql

sed -n '/CREATE TABLE `mytable`/,/ENGINE=/p' full_dump.sql > mytable.sql

Change table name

sed -E "s/\`entity_schemas\`/\`entity_schemas_bkp19feb\`/g" entity_schemas.sql > entity_schemas_bkp19feb.sql

Import table 

mysql probsolvdbqa < entity_schemas_bkp19feb.sql

grep -n -E "character_set_client|character_set_results|collation_connection" entity_schemas_bkp19feb.sql

ERROR 1231 (42000) at line 13: Variable 'character_set_client' can't be set to the value of 'NULL'

grep -n -E "character_set_client|character_set_results|collation_connection" your_dump.sql

mysql --default-character-set=utf8mb4 probsolvdbqa < entity_schemas_bkp19feb.sql

SET @saved_cs_client = 'utf8mb4';

SOURCE /mariadb_8dqa/back/entity_schemas_bkp19feb.sql;

ls -lrt 

When you have 2 databases with same name table -

sed -n '/^USE `probsolvdbqa`;/,/^USE `/p' dbbackup_full_20260219.2100.sql | sed -n '/CREATE TABLE `entity_schemas`/,/UNLOCK TABLES;/p' > entity_schemas_bkp_new.sql

sed -n '/^USE `db2`;/,/^USE `/p' dbbackup_full_20260219.2100.sql \

  | sed -n '/CREATE TABLE `entity_schemas`/,/UNLOCK TABLES;/p' \

  > entity_schemas_db2.sql

Change table name

sed -E "s/\`entity_schemas\`/\`entity_schemas_bkp19feb\`/g" entity_schemas_bkp_new.sql > entity_schemas_bkp20feb.sql