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/
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.