MySQL Forums
Forum List  »  Data Recovery

extract tables from large mySQL dump with regex or wildcards?
Posted by: Allen Moore
Date: July 08, 2021 02:31PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
extract tables from large mySQL dump with regex or wildcards?
417
July 08, 2021 02:31PM


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.