How to Import and Export MySQL Database Command line in Linux

************
TO EXPORT
************

1. SSH login as root.

2. Run command 

mysqldump -a -u ejobsolution_db_user --password=db_password ejobsolution_db > ejobsolution_db.sql

Download ejobsolution_db.sql from root directory

Reference: https://webhostinggeeks.com/howto/import-and-export-mysql-database-command-line-in-linux/

Reference: https://archive.virtualmin.com/node/6032

How to Export MySQL Database Command line in Linux

1. Syntax to Export:

mysqldump -u USERNAME -p DATABASE_NAME > filename.sql

How to Export MySQL Database Command line in Linux

2. Syntax to Import:

mysql -u USERNAME -p DATABASE_NAME < filename.sql

CREATE USER 'db_user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'db_user'@'localhost';
mysql -u db_user -p
CREATE DATABASE db_name;