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.