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.
- 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.
mysql -u db_user_name -p db_name < /complete/file/path.sql
Queries and comments are welcome.