CODE EXAMPLE FOR SHELL

mysqldump database

#To export single database
mysqldump -h [server] -u [user] -p [database_name]  | gzip > [filename].gz