Web lists-archives.com

Re: moving inno tables

> From: Martin Mueller <martinmueller@xxxxxxxxxxxxxxxx>
> 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.

Oh dear. Hope you have a backup.

I fought with this for several days. I ended up deleting the bad file, creating an identical table in another database, moving THAT file into the old file's location, then using DROP TABLE on that file, then restoring from backup.

Until I did that, it wouldn't let me do ANYTHING with the table; couldn't DROP it (it didn't exist!) but couldn't create or rename a new one with the same name, either.

In general, moving database tables using the file system is A Very Bad Idea. Only use MySQL commands to move things around.

:::: I value kindness to human beings first of all, and kindness to animals. I don't respect the law; I have a total irreverence for anything connected with society except that which makes the roads safer, the beer stronger, the food cheaper, and old men and women warmer in the winter, and happier in the summer. -- Brendan Behan
:::: Jan Steinman, EcoReality Co-op ::::

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql