mysqldump-to-csv

mysqldump-to-csv copied to clipboard

Cannot process file due to csv header data

5

"SQL INSERT statement could not be found!" check is performed on all lines, in case if there is header data in the sql file, the script will refuse to process...

enaix

If there is a special symbol in the SQL dump, csv writer will throw "_csv.Error: need to escape, but no escapechar set"

enaix

removing '

1

bbarclay

Create a new csv file for the result

1

For anyone who wants to create a new csv file for the result, just add ```{Python} sys.stdout = open('Result.csv', 'a') ``` in the beginning of the code.

RedArmy95

Automatically skip non-insert lines and other sql meta data

JohnPremKumar