#1146 - table doesn't exist but showing in sidebar in phpmyadmin

Question

I copy my database files from windows

wamp/bin/mysql/mysql5.6.17/data

into my ubuntu

/var/lib/mysql/

Folders of my database_name and ibdata1, ib_logfile0, ib_logfile1 files. Now my all databases and tables are visible into phpmyadmin but when selecting any table, it shows table doesn't exist

How to get back my all the data

Here is the screenshot.

Answer 1

After Googling a lot I found the answer.

Restart your mysql

sudo mysql stop

sudo mysql start

Refresh the phpmyadmin page

Answer 2

I have solved the problem in ubuntu 18.2 using >> sudo chown -R mysql:mysql var/mysql/