Difference between revisions of "Putty and winscp"

From SQLZOO
Jump to: navigation, search
 
Line 1: Line 1:
 
Start WinScp to connect inf08104.napier.ac.uk
 
Start WinScp to connect inf08104.napier.ac.uk
 
==Start WinScp==
 
==Start WinScp==
 +
Off Campus? If so you will need to to follow this instead [[Putty and winscp off campus]]
 
[[File:winscp1.png]]
 
[[File:winscp1.png]]
 
==Click New==
 
==Click New==

Latest revision as of 16:40, 3 November 2016

Start WinScp to connect inf08104.napier.ac.uk

Start WinScp

Off Campus? If so you will need to to follow this instead Putty and winscp off campus Winscp1.png

Click New

Winscp3.png

Enter details of the server

Winscp2.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