How do I dump only the data for all tables using mysqldump

Question

I have a new database with schema and primary key, FK, index constraints created for all tables. How do I dump only the data from an existing database using mysqldump, so that I can import only the values alone and exclude everything else.

Answer 1

mysqldump --no-create-db --no-create-info  ...options...

See http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html

Answer 2

Use this in putty.........

mysqldump -u username -p'password' $db_name > $db_backup.sql