frankyonnetti
12/12/2013 - 6:22 PM

#terminal #MySQL commands

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