MySQL Forums
Forum List  »  Data Recovery

Advanced Search
New Topic

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?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
extract tables from large mySQL dump with regex or wildcards?
1191
Allen Moore
July 08, 2021 02:31PM
Re: extract tables from large mySQL dump with regex or wildcards?
497
Peter Brawley
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.