MySQL Snippets

SELECT ... INTO OUTFILE '/tmp/mycsvfile.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n';

mysql -u USERNAME -p DATABASE < DUMPFILE.SQL

If your constantly having headaches dumping data to MySQL and it errors out because of foreign keys, you can do:SET FOREIGN_KEY_CHECKS=0;-- dump --SET FOREIGN_KEY_CHECKS=1;