Question mysql.user table does not exist recovery?!

[SalamiC]

Hi Forum Folks,

on a client machine the mysql.user table does not exist anymore. Is there a way to recover it from a auto backup?

The machine is a Windows Server 2016 running Ples Onyx 17.5.3. All Components are out-of-the-box.

Any idea is highly appreciated.
Salami C.

 

[khoubeib bach]

Hi,
You have to search for backup file .sql if exist of course then restore it
Before upgrading Plesk or installing important MySQL updates, Plesk Installer creates a pre-upgrade dump of system databases. Pre-upgrade dumps are used to restore the system to previous state if Plesk upgrade/update has failed.
The following databases are included in it (in order of appearance):

• mysql - MySQL system database
• psa - Plesk system database
• apsc - Plesk application database
• horde - Horde database, if installed

Windows Server
On Windows servers, every night Plesk automatically creates a daily dump of system databases in scope of the scheduled task Backup of vital Plesk settings in Windows Task Scheduler (command C:\Program Files (x86)\Plesk\admin\bin\sshost.exe --settings-backup).

These dump files are located in %plesk_dir%Mysql\Backup. The following Plesk databases are backed up:

• psa - Plesk system database
• apsc - Plesk application database
• horde - Horde database, if installed

How to back up / restore Plesk system databases

 

[SalamiC]

Hi khoubeib bach,

that's what I found in the %plesk_dir%\Mysql\Backup folder, see attached. Is it that, what I'm looking for?

I also check now, the linked how to article.

Thx so far.

 

[khoubeib bach]

Hi
From the screen shot it's seems that the mysql db backup is not present unfortunately

 

[SalamiC]

You are right, I could not found a mysql backup. With what I had, I gave it some tries, without success.

Now, I moved to a regular web hosting and at the moment I'm uploading the last working copy of the website.

Thanks for your help!
Salami C