Urgent help for mysqldump


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.


One guess, do you have enough disk space to hold the backup file? Maybe /root/backup is on a small partition.