MySQL 4 to MySQL 5: PRIMARY & INDEX vs BTREE ?

Get answers here.

Moderators: BBear, theunknownhost, flaguy

Post Reply
User avatar
Sapphyre
Official Test Penquin
Posts: 3337
Joined: Tue Nov 19, 2002 2:50 am
Location: Canada

MySQL 4 to MySQL 5: PRIMARY & INDEX vs BTREE ?

Post by Sapphyre » Wed Nov 30, 2011 11:27 pm

I imported a DB via PHPMyAdmin and all the PRIMARY KEY and KEY designations which are PRIMARY and INDEX when seen in the "structure" ended up as BTREE in the new DB.

Is this going to cause a problem - do they need to be corrected?

The SQL dump had them spec'd like this:
PRIMARY KEY (clickid),
KEY index_page (page),
KEY index_domain_referrerdomain_date (domain,referrerdomain,date),
KEY channel (channel),
KEY index_year_month_day_hour (year,month,day,hour),
KEY index_keywords_date (keywords,date),
KEY index_ip (ip),
KEY index_referrer (referrer)
or this
PRIMARY KEY (ID),
UNIQUE KEY ID (ID),
KEY ID_2 (ID)
Was imported in PHPMyAdmin with compatibility mode: MYSQL40

User avatar
Sapphyre
Official Test Penquin
Posts: 3337
Joined: Tue Nov 19, 2002 2:50 am
Location: Canada

Post by Sapphyre » Thu Dec 01, 2011 12:15 am

Maybe a PHPMyAdmin display bug?
Oddly enough, when exported from the new PHPMyAdmin, the SQL comes out the same for the key specs except for the addition of backticks:
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`),
KEY `ID_2` (`ID`)
No mention of BTREE at all here.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest