copper:/etc/amanda # amrecover
AMRECOVER Version 2.5.1p2. Contacting server on quartz.zmanda.com …
220 quartz AMANDA index server (2.5.1p2) ready.
Setting restore date to today (2007-01-08)
200 Working date set to 2007-01-08.
200 Config set to DailySet1.
501 Host copper is not in your disklist.
Trying host copper.zmanda.com …
200 Dump host set to copper.zmanda.com.
Use the setdisk command to choose dump disk to recover
amrecover> 

More...

Using mysqldump, the example goes here :

#mysqldump -uroot -prootpassword database_name

If we use gzip for the compression :

#mysqldump -uroot -prootpassword database_name | gzip > /home/admin/backup_mysql.sql.gz without the gzip :

#mysqldump -uroot -prootpassword database_name > /home/admin/backup_mysql.sql