My SQL backup From Linux Console

0
23
To schedule a mysql database backup it is necessary to take the back up from Console with out prompting pasword,
to call crom scheduler crontab
Use the following to backup to sql script
]# mysqldump -h localhost -u root -pabcd db> joomla_bup.sql

to backup in the name of dates

]# mysqldump -h localhost -u root -pabcd db> joomla_bup.sql$(date)

LEAVE A REPLY

Please enter your comment!
Please enter your name here