How to Import MySQL Database via SSH
SSH, or Secure Shell, is a secure protocol for connecting to a remote server.
Requirements For Set-Up:
– Server IP Address
– SSH port
– SSH username
– SSH password
Application:
Linux:
Click Ctrl + Alt + T or Search → Terminal to run the terminal.
Mac OS:
In Spotlight search for Terminal.
Windows:
Download an SSH client that is suitable for you. I recommend PuTTY.
Format:mysql -u databaseuser -p databasepassword databasename < mydatabase.sql
Basic SSH Commands
SSH – Command Explanationls
– Show directory contents (list the names of files).cd
– Change Directory.mkdir
– Create a new folder (directory).touch
– Create a new file.rm
– Remove a file.cat
– Show contents of a file.pwd
– Show current directory (full path to where you are right now).cp
– Copy file/folder.mv
– Move file/folder.grep
– Search for a specific phrase in file/lines.find
– Search files and directories.vi/nano
– Text editors.history
– Show last 50 used commands.clear
– Clear the terminal screen.tar
– Create & Unpack compressed archives.wget
– Download files from the internet.du
– Get file size.