XF 2.0 Mysql Issues

[runescapejon]

Hello,

I'll write the information that i am having trouble with. getting this error on the forums, Table 'forumsdatabase.xf_data_registry' doesn't exist here a screenshot of the table actually being therehttps://gyazo.com/42608f9d2ab43f1c1e430ce38bf8fa2b as you see it's there and i have tried googling and reading few things and they mostly said to run this ALTER TABLE xf_data_registry DISCARD TABLESPACE;
as i did i get this Table 'forumsdatabase.xf_data_registry' doesn't exist in engine error when i even tried to export to have an backup .sql file i get this mysqldump: Got error: 1932: "Table 'forumsdatabase.xf_data_registry' doesn't exist in engine" when using LOCK TABLES

I have also tried to create it and it just said that it already exist

 

[runescapejon]

Just putting additional information about my issue i had look into error.log within the /var/log/mysql/error.log directory
and it spams with this with different tables

2018-04-22 23:16:29 139689479411456 [Warning] InnoDB: Cannot open table forumsdatabase/xf_option from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

I had tried reading the troubleshooting but unable to find a fix for this issue, i found this by googling
https://dba.stackexchange.com/quest...sql-tables-from-ibd-frm-and-mysqllogbin-files
looking on the answers and attempt to do step 2 it give me this

WARNING: Using a password on the command line interface can be insecure.
# Source on localhost: ... connected.
# Spawning server with --user=root.
# Starting the spawned server on port 3307 ... ERROR: Failed to kill process with pid '31311'

it kept saying that with different ports and even tried sudo kill [pid] or kill -9 [pid] it said does not exisit
if anyone can help me with this issue i greatly appreciated

 

[rdn]

How did you solve this issue?

 

[runescapejon]

ahh well i didn't fix it what i end up finding is my old backup and from there i had restored from an early backup but before i did that i had reinstall mysql fresh clean and made sure that it's working properly then i put back the backup database for xenforo and have crontab perform automatic monthly backup of all mysql. I cannot tell you how much backup are important here but if you can find a fix please tell me about it so others who are reading this can fix it them self and i can learn from this issue thanks.