Versiones comparadas

Clave

  • Se ha añadido esta línea.
  • Se ha eliminado esta línea.
  • El formato se ha cambiado.

...

WinSCP will be used to send to the remote system, and the script will be executed on the remote system from a PuTTY session. Since the script has few lines, you could also not use WinSCP and use a terminal text editor (such as nano) to directly create the contents of the script on the remote system.

 


1-      Before carrying out the connection to the machine it will be necessary to have:

  • The IP address (or host address) of the machine.
  • An open port 22 on the machine for connection (or another ssh-enabled port)
  • Authentication credentials to connect to machine

2-      Connection via PuTTY

  • If you do not have it, you can download PuTTY from the following location
  • The IP address to which to connect is written in the main window of Putty.
  • The port is written, for SSH connections it is usually used port 22)
  • In the login window, the authentication credentials are written.

3-  Once the SSH is started, the file system of the machine should be accessible. Navigate to the directory where the script will be created and run. This manual used the directory /home/fuseadmin/Downloads/

cd ~/Downloads/

If you do not want to use WinSCP, once you have made the necessary edits to the script, you can open a text editor and create the script directly from the PuTTY session using nano.

Nano GenerationDatos.sql

Paste the contents, save (Ctrl + O) and exit nano (Ctrl + X)

...