Command to import DB through the command line in MySQL

May 25, 2019 by Mohammed Samgan Khan

upload your SQL file to the serve through FTP. Ones the file is on server you can user the following command.

Assumptions

• you have created a DB
• you have already create a DB user with privileges as per required.
• you have ssh access to the server
• you know how to log in through ssh into your server.

Command

mysql -u db_user_name -p db_name < /complete/file/path.sql

Queries and comments are welcome.