MySQL Database Import & Export Via Command Line

Windows
======================

Export Database :
mysqldump -u root -p DATABASE_NAME > d:/EXPORT_DATABASE_NAME.sql

Import Database :
mysql -u root -p DATABASE_NAME < d:/IMPORT_DATABASE_NAME.sql

Mac
=======================
Database Import in Mac
/Applications/xampp/xamppfiles/bin/mysql -u root -p DATABASE_NAME < /Users/MAC_USERNAME/Downloads/DATABASE_NAME.sql

Database Export in Mac
/Applications/xampp/xamppfiles/bin/mysqldump -u root -p --databases DATABASE_NAME > /Users/MAC_USERNAME/Downloads/DATABASE_NAME