mySql

Links

• mySql site

Code snippets

Foreign key

Below is statement used to set the foreign key checks. It is used when several tables are imported and, due to the order of the import would cause foreign key check violations.

  set FOREIGN_KEY_CHECKS=0

mysql dump

Below is statement used to copy an entire database from the command line.

  mysqldump --user=userName -p dbName >> fileName.sql

Execute mySql code from file

Below is statement that will pipe sql from a text file into a mysql db from the command line. Be sure you specify which db to use (use dbName;)

  mysql -u bm -p < barmenuBU.sql