MySQL Snippets

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;