Export Data From Server Using Terminal

To Export Data from Terminal Use Following Command :


mysql -p -u databasename > databasename.sql 
OR
mysqldump -p -u databasename > databasename.sql




To Import Data from Terminal Use Following Command :

mysql -p -u databasename < databasename.sql

OR
mysqldump -p -u databasename > databasename.sql