0

From the 'data' folder of my colleague I copied the entire 'MyDatabase' folder and pasted that in my own 'data' folder.
Now, some tables are getting recognized while others are not.
**All the tables are in .frm format.

Some random tables are not getting imported. All the tables that I have are InnoDB with only two MyISAM tables. Many InnoDB tables and both the MyISAM tables are working fine. It's just that some random tables are not working.

  • 1
    Just don't do that. Don't copy and move data directories. Use mysqldump. – ypercubeᵀᴹ Aug 11 '15 at 10:12
  • @ypercube: Thats what I have been trying for weeks. Checkout this post.stackoverflow.com/questions/31310239/… – Farrukh Chishti Aug 11 '15 at 10:14
  • 2
    I can vote to bring that question in this site but please do edit it and add details of what exact command you run, how big the dump was, what version of MySQL you have on Windows, how the dump was taken, in what OS and mysql version the dump was taken, etc. – ypercubeᵀᴹ Aug 11 '15 at 10:18
  • @ypercube: My bad. I have updated all the details here... dba.stackexchange.com/questions/106572/… – Farrukh Chishti Aug 11 '15 at 10:34
1

The ".frm" file holds table definition. You might want to check mysql file-types info.

Usually when you move data-base physically do following:

  • Shutdown mysql
  • Copy datafiles to datadir
  • make sure mysql has full permissions on it: chown mysql:mysql datadir/ -R
  • start mysql

So, make sure that the tables which are not "visible" have proper permissions for mysql to access it.

Also, when you say you moved "database" do you mean all-databases-on-server or single-database? If your database have innodb tables you cannot move them like this!

|improve this answer|||||
  • I have many InnoDB tables but there is no problem accessing them. Only a few particular tables are giving this issue. Also, I found that its a common error, but there is no direct solution.google.co.in/… – Farrukh Chishti Aug 11 '15 at 10:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.