mysql dump & import

mysql-dump-import.sh

#import
gunzip < backupfile.sql.gz | mysql -uroot -ppassw database

#dump
mysqldump -h -u -p database | gzip > backupfile.sql.gz

#dump without schema(data only)
mysqldump --no-create-info --skip-triggers -h -u -p database | gzip > backupfile.sql.gz

#dump with columns
mysqldump --complete-insert --no-create-info --skip-triggers -h -u -p database | gzip > backupfile.sql.gz

#--ignore-table=database
mysqldump --complete-insert --no-create-info --skip-triggers --ignore-table=database.table -u -p database  | gzip > backupfile.sql.gz


--set-gtid-purged=OFF
--skip-lock-tables

#with pv
mysqldump |pv| gzip -c > backupfile.sql.gz