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

If you are using amazon RDS, you need to alter the command by adding the host to the command

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

Queries and comments are welcome.