need help with mysql error 1168

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

need help with mysql error 1168

Post 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?
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
User avatar
aaronhall
DevNet Resident
Posts: 1040
Joined: Tue Aug 13, 2002 5:10 pm
Location: Back in Phoenix, missing the microbrews
Contact:

Re: need help with mysql error 1168

Post 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.
Post Reply