Issue Database sys

[vanen]

We deleted by mistake database named "sys". We don't have any backup. How to recover it?

 

[Bitpalast]

We deleted ... We don't have any backup ... How to recover it?

Doesn't your question also answer itself? You don't have a backup. How do you expect to recover a database that was deleted when you do not have a backup?

 

[vanen]

any way to create a default one? What sys is used for?

 

[Bitpalast]

Plesk does not have a "sys" database. It uses the "psa" database.

 

[vanen]

so, what is "sys" used for?

 

[Bitpalast]

Maybe you can look into it to see what tables it contains and maybe find something useful in the tables that hint the purpose of your database named "sys"?

 

[weltonw]

Maybe you can look into it to see what tables it contains and maybe find something useful in the tables that hint the purpose of your database named "sys"?

Might be hard assuming he deleted it

We deleted by mistake database named "sys". We don't have any backup. How to recover it?

There is no real way to recover it if you have absolutely no backups. Maybe check with your service provider to see if they keep backups. If it was extremely important data, you may be able to ship it to a forensics lab and see what they can scrape off. Otherwise, you're likely out of luck.

 

[LTUser]

We deleted by mistake database named "sys". We don't have any backup. How to recover it?

You neither share which operating system, which database server, whether you are using a root server or a cloud server. So you can hardly be helped.
A very small possibility to help you would be this command for the SSH console ...
Use at your own risk

/usr/bin//mysql_upgrade -fs -uroot -p

 

[Bitpalast]

Might be hard assuming he deleted it

Oh yes, right, I forgot all about that.

 

[Maarten]

Could it be that you talk about the MySQL sys schema?

Here's a way to import it:

GitHub - mysql/mysql-sys: The MySQL sys schema

The MySQL sys schema. Contribute to mysql/mysql-sys development by creating an account on GitHub.

github.com