Export and import from MySQL

# export structure only (no data) as sql
mysqldump -u root -pthePasssword --no-data theDbName > mydata.sql
 
# export with data as sql
mysqldump -u root -pthePasssword --default-character-set=latin1 --skip-set-charset theDbName > mydata.sql
 
# import sql
mysql -u root -pthePasssword -D theDbName < mydata.sql
 
# export data as a comma separated values document
SELECT * INTO OUTFILE '/tmp/mydata.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM mydata;
 
# import data from a comma separated values document
LOAD DATA LOCAL INFILE '/tmp/mydata.csv' INTO TABLE mydata FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';