Use the sed command on your bash shell to separate the data of the table that you want to restore. For example, if we want to restore only the “film_actor” table to “sakila” database we execute the script below.
sed -n -e '/DROP TABLE.*`mytable`/,/UNLOCK TABLES/p' mydump.sql > tabledump.sql
You can now import the newly created table dump file into MySQL database.
mysql -u root -p sakila < film_actor.sql
Cheers!
Thank you so much, it saved my partial database
You’re welcome Pratibha, Keep up the great work!