Issue Download Plesk mysql database on broken server via SSH?

[hillcow]

I did something incredibly stupid. This command ruined file permissions on my whole server:

sudo chown -R www-data:www-data /

Nothing works any longer. MySQL fails, I cannot access any of my websites/Plesk backend or anything else.

The only thing I have is root ssh access.

The only thing I need from my server is the current database of my website. How can I possibly get it?

 

[IgorG]

If you have CentOS server you could try to restore default permissions there with help of this KB article How to restore corrupted Plesk permissions and ownership on RedHat based systems

The only thing I need from my server is the current database of my website. How can I possibly get it?

You can find it in /var/lib/psa/dumps/domains/domain.tld/databases/

 

[hillcow]

Oh my god, thank you so much! Unfortunately I am running Debian 8.

Okay, so what is the best way to restore these dumps onto a new server?

Basically what I need to do is to get a new Plesk instance running on a new server and then somehow get all the content from the not-working server back onto the new one. What happens, when I simply copy the entire /var/lib/psa/dumps/ folder to my new server, where the domains have not been setup?

Thank you SO much!

 

[IgorG]

What happens, when I simply copy the entire /var/lib/psa/dumps/ folder to my new server, where the domains have not been setup?

No, it is just dump of databases, you have to create an empty database for your site with the same name and then import this dump.
But do you have Plesk backups of your not-working server? In this case, restoring backups would be a better solution.

 

[hillcow]

Thank you! Where are these Plesk backups located?

 

[IgorG]

Thank you! Where are these Plesk backups located?

Where you specified during the backup setup process.

 

[hillcow]

What's the default? I didn't manually download backups, but I did setup plesk do run regular backups on the server side.

 

[IgorG]

By default, all backup data is stored in the directory /var/lib/psa/dumps.

 

[hillcow]

I managed to recover my server, so everything is back to normal.

For testing purposes I successfully imported a db backup from var/lib/psa/dumps/domains/...

What I am still not sure about: My back up settings say [Server storage in /var/lib/psa/dumps].

When I manually download a complete backup I get a "backup_info_XXXXXXX.tar" file. How can I download this file via ssh without using Plesk at all? Because I can only find a .xml file named similiarly in the /dumps folder.