How to make a backup of MySQL
mysqldump -a -c --host=hostname --user=userid --password=pwd --result-file=filename --all-databases