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;
Comments
Post a Comment