How to Export and Import MySQL Db dump from command line

Go to the command line as root or admin user


Export the database

mysql -u UserName -p password databaseName > dbdump.sql

Import the database

mysql -u UserName -p password databaseName < dbdump.sql