Mysql Tidbits

Code that I just wanna keep track of so I don't have to keep searching the same dumb thing.

Import a database

You must create the database before importing.

mysql -u username -p new_database < data-dump.sql

export a database

mysqldump -u username -p database_name > data-dump.sql