MySQL Cheat Sheet

1. Connect to MySQL server in localhost

>mysql -u username -p password [databasename]

2. Executing SQL Statements from a Text File

mysql> source c:\filename.sql

3. Migrate database

# everything
$ mysqldump -u [user] -p --opt mydb > mydb.sql

# To export to file (data only)
mysqldump -u [user] -p --no-create-info mydb > mydb.sql

# To export to file (structure only)
mysqldump -u [user] -p --no-data mydb > mydb.sql

# To import to database
mysql -u [user] -p mydb < mydb.sql