Difference between revisions of "Putty and winscp off campus"

From SQLZOO
Jump to: navigation, search
(Enter details of the server)
(Enter details of the server)
Line 6: Line 6:
 
==Enter details of the server==
 
==Enter details of the server==
 
Enter the target machine
 
Enter the target machine
 +
 
[[File:winscp2.png]]
 
[[File:winscp2.png]]
 +
 
You are off campus so you must tunnel in via socweb8.napier.ac.uk
 
You are off campus so you must tunnel in via socweb8.napier.ac.uk
 
*Tick '''Advanced Options'''
 
*Tick '''Advanced Options'''
 +
 
[[File:tunnel.png]]
 
[[File:tunnel.png]]
  

Revision as of 16:00, 3 November 2016

Start WinScp to connect inf08104.napier.ac.uk

Start WinScp

Winscp1.png

Click New

Winscp3.png

Enter details of the server

Enter the target machine

Winscp2.png

You are off campus so you must tunnel in via socweb8.napier.ac.uk

  • Tick Advanced Options

Tunnel.png

Create a new file (called mksrs.sql or similar)

Winscp4.png

Write your SQL

Winscp5.png

Try it in mysql

  • Start putty, connect to inf08104.napier.ac.uk
  • Go into the mysql prompt
    mysql -u 40000036 -ptiger 40000036
  • Load in the file
    \. mksrc.sql

Putty10.png