Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

How to extract tables without headers #8

Open
sHAsHiLx opened this issue Nov 23, 2017 · 1 comment
Open

How to extract tables without headers #8

sHAsHiLx opened this issue Nov 23, 2017 · 1 comment

Comments

@sHAsHiLx
Copy link

Having dump without any headers, just pure data, so dump looks like

INSERT INTO members10 VALUES (...
INSERT INTO members11 VALUES (...
INSERT INTO members12 VALUES (...
INSERT INTO members13 VALUES (...

as I see when I choose option "--match_str members10" it search for "-- Table structure for table members10" but it's not in dump. Dump is just pure data without database structure. Structure created from other dump. File is 100gb sized and I need to split it in files members10 members11 members12 etc.
@kedarvj
Copy link
Owner

kedarvj commented Jun 17, 2019

Right. Script doesn't work well with sql files created with --no-create-info. Will look to improve.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@kedarvj @sHAsHiLx