navicate for MySQL export SQL script and then process through notepad++ regular expression

navicate for MySQL export SQL script and then process through notepad++

Use target: Extract all drop table SQL scripts

：

My operation steps:

Step 1, select a database in navicate for MySQL, then right-click Dump SQL File and choose Save Path,

will be saved as a SQL script file, including insert scripts for table and table.

Step 2, open the SQL script file and copy to notepad++

Step 3, in notepad++, find mode select "Regular expression"

Note that the following regular expression strings are "find target", "replaced with" not filled, which is empty, "replace all" in the point "replace",

>>>>>>>>>>>>>>>>>>

^insert into. *;$
^create.*$
^  `.*`.*$
^ primary.*$
^\) engine=myisam.*$
^--.*$
\r\n\r\n

<<<<<<<<<<<<<<<<<<<

Step 4: Continue with the following 2 substitution actions, find pattern or regular expression,

Fill in the "Find target" and "Replace with" respectively, point all replace

>>>>>>>>>>>>>>>>>>>

;D ROP
; \r\ndrop


SET
\r\n\r\nset

<<<<<<<<<<<<<<<<<<<

Step 5: If it doesn't go wrong, you can theoretically get the same results as me.

End

navicate for MySQL export SQL script and then process through notepad++ regular expression