MySQLDump one INSERT statement for each data row
with the following statement: mysqldump –complete-insert –lock-all-tables –no-create-db –no-create-info –extended-insert –password=XXX -u XXX –dump-date yyy > yyy_dataOnly.sql I get INSERT statements like the following: INSERT INTO `table` VALUES (1,’something’),(2,’anything’),(3,’everything’); What I need in my case is something like this: INSERT INTO `table` VALUES (1,’something’); INSERT INTO `table` VALUES (2,’anything’); INSERT INTO `table` VALUES (3,’everything’); Is … Read more
