How to import/export database using MySql command line
The easiest way to export is to use command prompt (cmd):
mysqldump -u USER -p PASSWORD DATABASE > filename.sql
To import database from dump file use:
mysql -u username -p password database_name < filename.sql
