I dropped the sys schema while tinkering around mysql 8(current version). Is there a way to recover it. I am using ubuntu 20.04. I tried using the mysql documentation but I couldn't find anything relevant. Could someone with better experience help me with this? Thank you.
Go to the folder of the github repo.
Download the sys_schema folder using gitzip or any other available extensions. I personally used gitzip. Needless to say you can download the whole mysql-server repo but that would be inefficient as you do not need everything and it has a heavy download size.
Extract it to a folder and cd into it
Log in to the mysql client
mysql -u root -p
Import the sys_57.sql file. Don't mind the name, it is compatible with mysql 8. using
There you go, you have your sys schema back. Thanks to danblack for giving me a cue.
P.S akina this is computer, there is always a way