CPanel to SSH

Hi, I’m a marketing person, not an IT person trying to move a webpage from one address where I developed it to another where it will live for the client. I have no issues doing this in cPanel, however, SSH is new to me and presenting challenges.

I’ve got access to the new domain using SSH via WinSCP and uploaded the files to a folder, edited the config file, but I’m not able to get my site up.

Is anyone aware of instructions/documentation etc. to assist me along the way? Any pointers? I just cant see where the SQL is supposed to be uploaded to.

Really, any help or thoughts would be appreciated.