Mysql – #1146 – table doesn’t exist but showing in sidebar in phptheadmin

Apache2MySQLphpmyadmin

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.

Best Answer

After Googling a lot I found the answer.

Restart your mysql

sudo mysql stop

sudo mysql start

Refresh the phpmyadmin page

Related Topic