Via SSH CLI
Typically you want to SCP (secure copy) the SQL file to the server and run the
mysql client to import the SQL script.
To send the file to the server, one would use this command:
scp dump.sql firstname.lastname@example.org:
Then you would SSH to
my-server.com and run the following command to import your database:
mysql my_database < /path/to/dump.sql
mysql is the MySQL CLI client application (For Debian/Ubuntu:
sudo apt-get install mysql-client)
my_database is the name of the database you want to import into
/path/to/dump.sql is the file path to the SQL dump file
Alternative via GUI Application
If you have a user account that can access from anywhere, you could use MySQL Workbench ( https://www.mysql.com/products/workbench/ ) to do the import through a GUI application.