Am 20.08.2015 um 23:06 schrieb Martin Mueller:
I moved the data directory of a MySQL installation from one computer to another. This works for MyISAM tables. Unfortunately I inadvertently created some INNO tables, and it doesn't seem to work. The show tables command accurately lists the following the tables from a longer list pospairs | | purchas4 | The ls -l command for the directory /usr/local/mysql/data/tcpcurrent shows what I take to be all the required files for these two tables: -rw-r----- 1 _mysql wheel 66152 Jul 28 15:53 pospairs.MYD -rw-r----- 1 _mysql wheel 45056 Jul 28 15:53 pospairs.MYI -rw-r----- 1 _mysql wheel 8664 Jul 28 15:53 pospairs.frm -rw-r----- 1 _mysql wheel 13792 Jul 28 15:53 purchas4.frm -rw-r----- 1 _mysql wheel 385875968 Jul 28 15:54 purchas4.ibd The permissions are identical, and the file sizes seem appropriate. But the first ISAM file responds while for the INNO file the command
you CAN NOT move / copy innodb tables that way because of the global tablespace - you can only dump / import or rsync *the complete* datadir
signature.asc
Description: OpenPGP digital signature
