Export Small or Large Database into Single SQL file

export.sql

#1. Export Database
mysqldump --host=YOUR_HOST --port=3306 --default-character-set=utf8 --user=YOUR_USERNAME --protocol=tcp --column-statistics=FALSE --skip-triggers "DB_NAME"

#Enter Password

#2. Export Database in Zipped Format if your database is too large.

mysqldump -h YOUR_HOST --set-gtid-purged=OFF -u YOUR_USERNAME -p DB_NAME | gzip > DB_NAME.sql.gz
#Enter Password

#3. Import Database from Zipped Database (Ubuntu)

gunzip < DB_NAME.sql.gz | mysql -h YOUR_HOST -u YOUR_USERNAME -p DB_NAME