How to dump and import sql into mysql (Command Line)
#EXPORT
mysqldump -u {USER} -h {IP} -p {DB_NAME} {DB_TABLE (OPTIONAL)} | gzip > dump.sql.gz
#IMPORT
CREATE DATABASE {DB_NAME}
mysql -u {USER} -h {IP} -p {DB_NAME} < dump.sql
option:-
-d : to dump only table structure out only