I can see frm and idb files in MySQL folders but unable to recover them.
I tried few software like staller, these tools are showing structure of the table but unable to show the data of the table.
When I put these frn and idb files in new instance of virtualmin, it shows table size increased but don’t show data. Further error shows that table doesn’t exist while I am able to click on the table.
You’ve got innodb databases which won’t just magically work. Make sure you have everything in /var/lib/mysql:
mysql (directory with .frm and .idb files)
ibdata1
ib_logfile0
ib_logfile1
databasedirs (directories with .frm and .idb files)
In /etc/my.cnf add the following:
innodb_force_recovery=1
then try starting mysql and see if you can see your databases and their contents. You’ll need to confirm that the files all have the correct ownership (mysql.mysql) and that the directories have the correct permissions.
Did you shutdown MySQL first. You may have to chown the copied files like so: sudo chown -R mysql:mysql /var/lib/mysql.
Copy database in your database folder (in linux, the default location is /var/lib/mysql). Keep same name of the database, and same name of database in mysql mode.