Web lists-archives.com

Re: moving inno tables






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

Attachment: signature.asc
Description: OpenPGP digital signature