I had this happen to me recently. I had to run a repair from within phpMyAdmin instead of the built-in WordPress repair.
Hopefully, you have a backup of your database. Once that’s taken care of, follow a tutorial to repair the database from your own cPanel using the phpMyAdmin feature. There should be a tutorial for your host.
But for example, here’s one for Siteground:
https://www.siteground.com/tutorials/phpmyadmin/repair-optimize-database/ or look for your own hosts’ instructions, just search the name of your host + repair database with phpmyadmin.
You’ll need to follow a couple of instructions and that will take care of it.
After this, my issue was resolved. It’s worth a try.
Thank you for your useful information. My website is back.