jet-tool icon indicating copy to clipboard operation
jet-tool copied to clipboard

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

Open tecdoc-ukr opened this issue 1 year ago • 0 comments

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" !

tecdoc-ukr avatar May 07 '24 09:05 tecdoc-ukr