A command line to convert mysqldump file to csv and sql file.
This command line is written with bash script and use awk
,a universally available text processing tool on any linux environment, to parse mysql-dump file.
dump2csv -s <dump filename>
or
dump2csv --source <dump filename>
Fix this issue: if table data contains text fields that contain the sequence of characters ),(
,awk
will split that field across multiple record lines.