Ideally MySQL include this in a future version of mysqldump
, but here's a neat little utility to split extended inserts into one row per line. This allows you to use extended inserts (for much faster importing of large tables) while having the ability to grep and diff rows easily.