How to import-export database in mysql using command line

For Export:

mysqldump -u root(user_name) -p (database_name) > (database_file_name).sql
Then Enter your password:



For Import:

mysql -u root(user_name) -p (database_name) < (database_file_name).sql
Then Enter your password: