I did a very foolish thing... I did not realize installing mariaDB would uninstall MYSQL 5.7 using apt-get. (Using Ubuntu 16.04).
So now I am trying to recover my data.
So far, I have read many guides and tried several things. I think this has gotten me into bad position, because the advice seems to be very version specific.
My most successful attempt is 1) Fresh install of MaraiDB. 2) copy * files from old sql directory to new. 3) Copy database directory myDatabase/ from old sql directory to new. 3) Run mysql_secure_installation 4) Configure my users, etc. etc.
This works except that I cannot run sql queries.
SELECT * FROM myDatabase.tableOne;
I get either:
SQL Error  [42S02]: (conn:56) Table 'myDatabase.tableOne' doesn't exist in engine
SQL Error  [42S02]: (conn:56) Table 'myDatabase.tableTwos'
It seems that all tables give one of these two errors.
So far, I have read that mysqlcheck can fix this.
If I run
/var/lib/mysql$ mysqlcheck myDatabase myDatabase.tableOne Error : Table 'myDatabase.tableOne' doesn't exist in engine status : Operation failed
I can't find any suggested solutions for fixing this. Although perhaps I went the wrong way from the beginning. Thanks for your help.