Page 1 of 1

need help with mysql error 1168

Posted: Fri Mar 14, 2008 12:53 am
by s.dot
I'm sure this is some kind of mysql setting or something, but I am getting the following error when trying to import a project database.

#1168 - Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist

I vaguely recall some error notice on phpmyadmin that something about merged tables isn't set right... I don't really know if that has anything to do with it.

Any help?

Re: need help with mysql error 1168

Posted: Fri Mar 14, 2008 1:40 am
by aaronhall
According to this, there's some weird compatibility issue when you create a MyISAM+Merge in 4.0 or 4.1 and then upgrade to 5.0 or 5.1. I assume the bug would pop up if you imported the database from/to the incompatible versions as well.