I am using mysqldump to export only the data from my database, but when exporting, it shows only one line with all the inserts. Is it possible to do one record insert per line? Ex:
INSERT INTO TABELA() VALUES();
INSERT INTO TABELA() VALUES();
I am using mysqldump to export only the data from my database, but when exporting, it shows only one line with all the inserts. Is it possible to do one record insert per line? Ex:
INSERT INTO TABELA() VALUES();
INSERT INTO TABELA() VALUES();
You can try this command:
mysqldump --extended-insert=FALSE
This response was found at this link: link