extract tables from large mySQL dump with regex or wildcards?
I need the ability to selectively restore a group of tables from a very large (100+Gb) mysql dump file with table names matching a specific pattern, such as regex "^brn_eraq".
In some cases I may not know all of the possible full table names, hence the need for pattern matching. Seems like I may have used sed in the past; but, only with full table names- no pattern matching. And, is there a way to list the table names contained in a mysql dump file?
Subject
Views
Written By
Posted
extract tables from large mySQL dump with regex or wildcards?
777
July 08, 2021 02:31PM
291
July 08, 2021 07:34PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.