Issue HELP: Plesk repair no such file or directory

[boosterfan]

Yes i thought that but i never set a mysql password.. plesk was installed with a file on our server from the provider.. so we got ssh password and plesk password, but no pw for mysql..

 

[boosterfan]

ok guys thanks for your help.. we will reinstall and work with a backup... dont know how to fix

 

[m3lezZ]

Yes..... cause the mysql password for the root user is placed on the system.

You can define the mysql-password for each user that you create in plesk.

 

[boosterfan]

what is the path for this, i dont know.. /full/path/to/BACKUP_FILE_NAME.sql ??

 

[m3lezZ]

Backup von Daten

How to backup or restore a Plesk database?

 

[boosterfan]

ok, when i try to restore i get error message "error 2002 (hy000) can connect to local my sql serverthrough socket .... no such file or directory

 

[m3lezZ]

1. Connect to the server via SSH
2. Make sure that MySQL is running. If not try to start it. If yes, this solution is not applicable.
3. Check /tmp/mysql.sock link file:
   

   # ls -l /tmp/mysql.sock 
   ls: cannot access /tmp/mysql.sock: No such file or directory

   
   
4. Create the link if it does not exist:
   

   # ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

 

[boosterfan]

Yes this happend:
ls: cannot access /tmp/mysql.sock: No such file or directory

So i created the link... And what to do now?

EDIT: mysql is not running seems like missing all relevant files to do so... maria down, no access to plesk..

EDIT2: still no way to restore databases... same error..

 

[m3lezZ]

mysql -V

service mariadb status

service mysqld status

Could you please reply the output so that we can help you?

 

[boosterfan]

we do not have access to the server anymore. We can not connect via ssh because firewall seems to block, but we couldnt deactivate firewall - all commands just leads to errors...

We will install and try to restore a backup..

So, we have a file backup_domainmail....tgz

Is it possible to restore the mails and so with that file or is this file useless for us?