- 提取create table sql
- perl -ne ‘print if /CREATE TABLE/../ENGINE=/’ dump.sql > create.sql
- 提取insert sql
- sed -n -r “/^INSERT INTO \`
(table1|table2|table3...)\`/p” dump.sql > data.sql
- sed -n -r “/^INSERT INTO \`
2023-07-06
提取mysql dump文件中特定表的sql
Comments Off on 提取mysql dump文件中特定表的sql
No Comments
No comments yet.
RSS feed for comments on this post.
Sorry, the comment form is closed at this time.