Mysql 5.7 : could not find valid tablespace file... Ignoring tablespace

[Venky Kannan]

Hi
We are getting below error in error lpg while starting mysql up.
"could not find valid tablespace file... Ignoring tablespace...."

We found the reason that our sysadmin moved the one the databases directory in var/data/ moved to other server directly,to free some space without informing to DBA or database developers. And he thought that this database not useful so we can. And also while he doing this he hasn't stopped mysql too. Then after three days he moved back that particular database directory to data directory var/data then he tried to restart the mysql. From that time we can't able to up the mysql. So please help us to fix this issue.

Thanks 😢