Terminal command to dump MySQL data:
mysqldump -u -p > /path/to/sqldump/db_database.sql
eg: mysqldump -uroot -padmin123 db_sports > /home/ec2-user/db_sports.sql
Import sql dump:
mysql -u -p < /path/of/sqldump/db_database.sql
ex: mysql -uroot -padmin123 db_sports < /home/ec2-user/db_sports.sql
Quick tip on MySQL dump
Reply