I have MySQL database with size around 500mb. I want to set cron for my database. I am using mysqldump command for this.

But the issue is with this command, it dumps the partial database having size around 270mb. The command I am using is

mysqldump -umyuser -pmypass -h127.0.0.1 mydb > /root/backup/`date +%A`/mydb.sql

Please help me with this.

Your help will be appreciated.