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.

Farrukh Chishti
  • 111
  • 4

1 Answers1

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!

mysql_user
  • 1,972
  • 13
  • 9