Issue If your install broken is it possible to download a website copy via SSH

[akira9000]

I have a feeling the simplest route on a machine with issues will be to take a copy of the site & DB over SSH if possible.

Is this a thing? Can I "grab" a copy over SSH to my desktop?

 

[IgorG]

Yes, just login to server via ssh, create dumps of databases, archives of your site content from /var/www/vhosts/example.com/httpdocs/ and download these files to your workstation with using scp command, for example.

 

[akira9000]

Unfortunately I can't create a new dump of the databases as my Plesk install is so badly damaged MariaDB won't run. I have found where the backups are kept:

/var/lib/psa/dumps/2

But how can I extract these on my desktop to show the correct sql file?

 

[IgorG]

But how can I extract these on my desktop to show the correct sql file?

I'm afraid that you can't do it without started mysql server.

 

[akira9000]

Thanks IgorG. I went in last night on SFTP and grabbed a not too old backup that had already been saved. It will do this time luckily.