Tural Aliyev Tural Aliyev - 10 months ago 59
MySQL Question

MySQL table "doesn't exist" error

I'm using Windows 7 Ultimate x64. After reinstalling OS copied back whole MySQL data directory to

. But now when i'm trying to open some table from restored db's with Navicat it shows me http://prntscr.com/2s9wl error. I don't know what to do. Please help.

Answer Source

First, the correct way to backup a database in MySQL is the mysqldump.

This http://www.softwareprojects.com/resources/programming/t-how-to-fix-mysql-database-myisam-innodb-1634.html step-through-step troubleshooting text is unix-centric, but it should be very similar for the Windows world.

Good luck.