mysqldump -u<user_name> -p<user_password> <database_name> > <file_name>.sql
# if your database is not locally hosted mysql -u username -p -h dbhost dbname < filename.sql
mysql -u<user_name> -puser_password> <database_name> source /path/db.sql
