Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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.
The ".frm" file holds table definition. You might want to check mysql file-types info.
Usually when you move data-base physically do following:
chown mysql:mysql datadir/ -RSo, 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!
