My SQL backup From Linux Console

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)
  • Share/Bookmark