Tip - Omit auto-increment values using mysqldump

If you want to export just the records, omiting the auto-increment id column, you should do this trick:

There is NO native way to do that only using mysqldump. So, enjoy.

Note: For Mac OS X users, use sed -E instead of sed -r.