Recover dropped mysql sys schema - Database Administrators Stack Exchange

Question

question from:https://stackoverflow.com/questions/66052199/recover-dropped-mysql-sys-schema

Answer 1

1. Go to the folder of the github repo.

2. 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.

3. Extract it to a folder and cd into it

4. Log in to the mysql client

   mysql -u root -p
   

5. Import the sys_57.sql file. Don't mind the name, it is compatible with mysql 8. using

   source ./sys_57.sql
   

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