mysqldump -h Your_host_name -u user_name -p password --all-databases > backup.sql

mysqldump -h 'hostname' -vv -u'user' -p'password' database_name table_name | gzip > table_name.sql.gz