2 add skip
source | link
mysqldump --skip-extended-insert

to break up the inserts.

Or

 SELECT ... INTO OUTFILE ... ORDER BY ...

to make sure the order is identical, thereby helping the diff program. (This assumes you have a PRIMARY or UNIQUE key.)

mysqldump --extended-insert

to break up the inserts.

Or

 SELECT ... INTO OUTFILE ... ORDER BY ...

to make sure the order is identical, thereby helping the diff program. (This assumes you have a PRIMARY or UNIQUE key.)

mysqldump --skip-extended-insert

to break up the inserts.

Or

 SELECT ... INTO OUTFILE ... ORDER BY ...

to make sure the order is identical, thereby helping the diff program. (This assumes you have a PRIMARY or UNIQUE key.)

1
source | link

mysqldump --extended-insert

to break up the inserts.

Or

 SELECT ... INTO OUTFILE ... ORDER BY ...

to make sure the order is identical, thereby helping the diff program. (This assumes you have a PRIMARY or UNIQUE key.)