Issue DB query failed: SQLSTATE[HY000] [1049] Unknown database 'psa'

[rh363]

Server operating system version

debian 11

Plesk version and microupdate number

Obsidian 18.0.55.2

i have manually reinstall mariadb and now i lost my psa database, my backup in /var/lib/psa/dumps have only my domain folder and inside it i have:

backup_apache-files_2310091443.tzst
backup_conf_2310091443.tzst
backup_domainmail_2310091443.tzst
backup_info_2310091443.xml
backup_logs_2310091443.tzst
backup_pd_2310091443.tzst
backup_privatekey_2310091443.tzst
backup_statistics_2310091443.tzst
backup_user-data_2310091443.tzst
databases/
I've already check databases folder but i cant find psa database for restore it .
please help me !!

 

[Peter Debik]

No files like

-rw-------. 1 root root 1049662 Oct 10 03:28 mysql.daily.dump.0.gz
-rw-------. 1 root root 1011318 Oct 9 03:33 mysql.daily.dump.1.gz
-rw-------. 1 root root 975112 Oct 8 03:52 mysql.daily.dump.2.gz
-rw-------. 1 root root 957197 Oct 7 03:58 mysql.daily.dump.3.gz
-rw-------. 1 root root 940587 Oct 6 03:14 mysql.daily.dump.4.gz
-rw-------. 1 root root 919138 Oct 5 03:35 mysql.daily.dump.5.gz
-rw-------. 1 root root 907977 Oct 4 03:56 mysql.daily.dump.6.gz
-rw-------. 1 root root 888414 Oct 3 03:17 mysql.daily.dump.7.gz
-rw-------. 1 root root 861009 Oct 2 03:13 mysql.daily.dump.8.gz

?

 

[rh363]

No files like

-rw-------. 1 root root 1049662 Oct 10 03:28 mysql.daily.dump.0.gz
-rw-------. 1 root root 1011318 Oct 9 03:33 mysql.daily.dump.1.gz
-rw-------. 1 root root 975112 Oct 8 03:52 mysql.daily.dump.2.gz
-rw-------. 1 root root 957197 Oct 7 03:58 mysql.daily.dump.3.gz
-rw-------. 1 root root 940587 Oct 6 03:14 mysql.daily.dump.4.gz
-rw-------. 1 root root 919138 Oct 5 03:35 mysql.daily.dump.5.gz
-rw-------. 1 root root 907977 Oct 4 03:56 mysql.daily.dump.6.gz
-rw-------. 1 root root 888414 Oct 3 03:17 mysql.daily.dump.7.gz
-rw-------. 1 root root 861009 Oct 2 03:13 mysql.daily.dump.8.gz

?

 

[rh363]

No files like

-rw-------. 1 root root 1049662 Oct 10 03:28 mysql.daily.dump.0.gz
-rw-------. 1 root root 1011318 Oct 9 03:33 mysql.daily.dump.1.gz
-rw-------. 1 root root 975112 Oct 8 03:52 mysql.daily.dump.2.gz
-rw-------. 1 root root 957197 Oct 7 03:58 mysql.daily.dump.3.gz
-rw-------. 1 root root 940587 Oct 6 03:14 mysql.daily.dump.4.gz
-rw-------. 1 root root 919138 Oct 5 03:35 mysql.daily.dump.5.gz
-rw-------. 1 root root 907977 Oct 4 03:56 mysql.daily.dump.6.gz
-rw-------. 1 root root 888414 Oct 3 03:17 mysql.daily.dump.7.gz
-rw-------. 1 root root 861009 Oct 2 03:13 mysql.daily.dump.8.gz

?

i dont have any file like this, i dont know why..

 

[Peter Debik]

These are in /var/lib/psa/dumps. You are several branches deeper. Try to "cd /var/lib/psa/dumps && ls -la".

 

[rh363]

These are in /var/lib/psa/dumps. You are several branches deeper. Try to "cd /var/lib/psa/dumps && ls -la".

today i find it but is a yesterday backup and yesterday I already didn't have 'psa' database. I'm stuck.View attachment 24486View attachment 24486

 

[Peter Debik]

Maybe the previous dumps were deleted along with other files? If no such dump exists, your only option is to restore the server content from a backup. Either a snapshot of the virtual machine (if you use that) or a Plesk backup that is restored into a fresh Plesk installation.

 

[rh363]

Maybe the previous dumps were deleted along with other files? If no such dump exists, your only option is to restore the server content from a backup. Either a snapshot of the virtual machine (if you use that) or a Plesk backup that is restored into a fresh Plesk installation.

yes i use a virtual machine for educational scope , if i cant resolve it by myself i must ask my tutor for virtual machine restore. thanks for your help!

 

[rh363]

Maybe the previous dumps were deleted along with other files? If no such dump exists, your only option is to restore the server content from a backup. Either a snapshot of the virtual machine (if you use that) or a Plesk backup that is restored into a fresh Plesk installation.

there is no way to recreate psa db from 0 right??

 

[Peter Debik]

The psa database contains all settings of Plesk and the associated user accounts, reseller accounts, subscriptions, domains, templates etc. An empty psa database is useless.