Export Mysql with gzip commands to properly create a compressed file & import in AWS

Question

Export with gzip commands to properly create a compressed file of a MySQL database & import to AWS RDS Server

Answer 1

Export From RDS Server:

mysqldump -h mywebinstance.rds.amazonaws.com -u myuser -p my-db-name | gzip > /var/www/html/dev-16-6-2022.sql.gz

Import to RDS Server:

gunzip < /var/www/html/dev-16-6-2022.sql.gz | mysql -h mywebinstance.rds.amazonaws.com -u myuser -p my-db-name