mysqldump is not dumping data by default

Question

mysqldump is dumping only the table structures, without data, by default.

mysqldump -u user -d database -p

Which is the option to dump is with data? How can I configure it, to include the data? (I guess it's possible with a setting in /etc/mysql/my.cnf)

Answer 1

Use only

mysqldump -u user -p database

The -d option means no-data :

   --no-data, -d

       Do not write any table row information (that is, do not dump table contents). This is useful if you want to dump only the CREATE TABLE
       statement for the table (for example, to create an empty copy of the table by loading the dump file).