magic is happening

Command to import DB through the command line in MySql

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Close
Social profiles