mysqldump - How do I dump MySQL file without Foreign Keys via command line?

Question

I need to export a large database without foreign keys. What is the command to do this?

This is what I tried but I know this is incorrect.

mysqldump -u root -p DBNAME SET FOREIGN_KEY_CHECKS = 0; | gzip > database.sql.gzip

Answer 1

you can use the --init-command flag on a per-session basis:

mysql --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;" ... < dump.sql