CODE EXAMPLE FOR SQL

mysqldump database

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