0

I have got a number of database on a local server. The server was cleaned up (disc cleanup) and mysql service was stopped. I tried to run the service again but it didn't work so I re-installed wampp. After installing it I could connect to mysql server and I see the databases and tables but it generates error 1146 once a table is clicked to open. Is there any way to restore the data from each database?

By the way, I have got a backup from mysql/bin folder which has been taken before installing wampp again.

Here is the error:

enter image description here

Hamid Ghorashi
  • 1,003
  • 3
  • 14
  • 29

1 Answers1

0

try to

  • Export the db
  • Delete them
  • Create them again with same names
  • Import the data into them

Is it possible to paste some of the exact error not only the code?

Miglen.com
  • 339
  • 1
  • 7
  • Now try my proposed solution and give us some feedback. – Miglen.com Apr 09 '15 at 09:54
  • what do u mean by export? you mean copy the entire database folder from bin directory or export using a tools like phpmyadmin? Actually, the second one is impossible since none of the tables are readable. – Hamid Ghorashi Apr 09 '15 at 10:01