Well, the question would by why it was turned on- it is generally only used to try to recover corrupted data temporarily, or as much as possible, for export, so that it can then be imported back/recovered into a new database. You are certainly not expected to run with it enabled, and as you see, the database becomes very strange.
So, the question basically is, was the database file corrupted, and was someone trying to recover it?
You can easily disable it, simply stop mysql, locate “my.ini” in the mysql install directory, edit it, and remove the line setting “innodb_force_recovery”. Then restart mysql. However, if the data file is actually corrupted, you might run into other problems.
If you have access to mysql tech support, they might be able to help you get things sorted out. If you’re just trying to test Ignition or get going on some project, it might be easier to just install another copy of mysql on a different computer, or side by side (when you install, pick a different directory, and then as part of the configuration, pick a different service name and port).
Hope this helps,