MySql commands

1. mysql -h localhost -u root -p

2. dump database
mysqldump -h localhost -u root -p DBNAME>c:\dumpfile.sql

3. restore database
mysql -h localhost -u root -p DBNAME<c:\dumpfile.sql