MySQL - commands #terminal #mysql
### MySQL ###
# MySQL commands:
http://www.pantz.org/software/mysql/mysqlcommands.html
# Create new database by logging in to mysql
$ mysql -uroot -p
mysql > create database DATABASENAME;
# MySQL dump
$ mysqldump -u -p --add-drop-table DATABASENAME > ~/mysql_dumps/DATABASENAME.sql
# MySQL import:
$ mysql -uroot -p website_dev < /Users/website_dev.sql
# MySQL login into database - use credentials in config file:
/usr/bin/mysql -h localhost -u DATABASENAME -p