MySQLdump no data export

Question

I want to do mysqldump with a table definition and table data every day, for this I configure the cron job with this command: "mysqldump -u user -pxxxxx site_DB | gzip> backup / site / site_t _ $ (date | awk {'print $ 1" "$ 2" "$ 3" _ ​​"$ 4 '}). Sql.gz", but this only exports the table definition. What is the right command to export data? Thanks

Answer 1

By default, mysqldump exports data - you must use the -no-data flag to make it only an export structure. Since your IS does this by default, this means that "no-data" is installed in your MySQL settings file, which you can find below these directions .

Answer 2

I had the same problem. re-run the dump command with '-databases' as follows:

mysqldump -u user -pxxxxx --databases site_DB . . . .