Sunday, October 2, 2011

Basic SQL

Host - localhost
user- root
password - root
DB Name - Feedback

Connecting to a DB
/Applications/MAMP/Library/bin/mysql -u root -proot

Exporting a DB
/Applications/MAMP/Library/bin/mysqldump -u root -p FEEDBACK > FEEDBACK.db

Importing Data into a DB
/Applications/MAMP/Library/bin/mysql -u root -proot -h localhost FEEDBACK < FEEDBACK.db