Pasted

# To export to file (data only)
mysqldump -u [user] -p[pass] -h host --column-statistics=0 --no-create-info mydb > mydb.sql
 
# To export to file (structure only)
mysqldump -u [user] -p[pass] -h host --column-statistics=0 --no-data mydb > mydb.sql
 
# To import to database
mysql -u [user] -p[pass] mydb < mydb.sql