Skip to content

[Solution] Create MySQL dump [It is no Issues] #16

@tecdoc-ukr

Description

@tecdoc-ukr

It is no Issues! It is Solution describe.
I use this "jet-tool" for export mdb databases to MySQL dump files in command line. "jet-tool" helps me a lot in this. The resulting dump file produced by "jet-tool" needs to be slightly adjusted. For this I use "fnr.exe --cl" utility (Find and Replace Tool).
Here is an example of some operation with "fnr.exe --cl" on schema dump fule:

:: replace for schema 
fnr.exe --cl --dir "%ResDest%" --fileMask "*%FileMysql%" --find " COUNTER " --replace " SMALLINT UNSIGNED "
fnr.exe --cl --dir "%ResDest%" --fileMask "*%FileMysql%" --find " TEXT(" --replace " VARCHAR("
fnr.exe --cl --dir "%ResDest%" --fileMask "*%FileMysql%" --find "[" --replace ""
fnr.exe --cl --dir "%ResDest%" --fileMask "*%FileMysql%" --find "]" --replace ""

Thank you author for "jet-tool" !

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions