Linux MySQL How to dump and import sql into mysql (Command Line) July 26, 2017January 9, 2018 by juliusgoh22 #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 juliusgoh22 Website https://juliusgoh.life