Yogesh Saroya
Yogesh Saroya

Reputation: 1495

Auto backup only for MySql database and selected folders in WHM or via cron job command

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

Answers (1)

Sadikhasan
Sadikhasan

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

Related Questions