Reputation: 1495
Hell all
i have a VPS, WHM provide use auto backup feature. but i want only backup some selected database and folder.
i try to use command via cron job but its not working.
current code (not working)
/usr/bin/mysqldump -u USERNAME -p PASSWORD DATABASENAME > /home/Backup/backup.sql
mysqldump -u USERNAME -p PASSWORD DATABASENAME > /home/Backup/backup.sql
can anyone know about that how can setup cron job for daily backup of database and folders.
Upvotes: 0
Views: 1773
Reputation: 18600
Try to remove space between username and password like
mysqldump -uUSERNAME -pPASSWORD DATABASENAME > /home/Backup/backup.sql
Check Manual for sqldump.
Upvotes: 1