Hello,
I know this is off-topic for this list but I know someone here may be able to help me out of a jam.
I ran the following against a table:
ALTER TABLE `products` ADD INDEX `idx_products_model` ( `products_model` );
Some things now appear broken but don't know if this was the culprit or not. If I can revert it back it its original state I may be able to determine if it's the cause of some new problems.
I did make a back up of the entire database before I made the change on 05-06-06 which I could restore but would lose all data from then til now.
Can this index be removed? If so, how?
TIA
ALTER TABLE `products` DROP INDEX `idx_products_model`;
you might consider running either mysqlcheck or mysqlisamchk first...
http://dev.mysql.com/doc/refman/5.0/en/myisamchk.html
http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
Be sure to read the docs about the differences. Don't just run one of these.
Thomas E Dukes wrote:
Can this index be removed? If so, how?
Thomas E Dukes wrote:
I ran the following against a table:
ALTER TABLE `products` ADD INDEX `idx_products_model` ( `products_model` );
Can this index be removed? If so, how?
Maybe DROP INDEX `idx_products_model` or ALTER TABLE `products` DROP INDEX `idx_products_model`
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Alan Sparks Sent: Tuesday, May 09, 2006 9:37 PM To: CentOS mailing list Subject: Re: [CentOS] OT: MySQL Help
Thomas E Dukes wrote:
I ran the following against a table:
ALTER TABLE `products` ADD INDEX `idx_products_model` ( `products_model` );
Can this index be removed? If so, how?
Maybe DROP INDEX `idx_products_model` or ALTER TABLE `products` DROP INDEX `idx_products_model`
Thanks for the help. Wasn't sure if 'DROP' was what I needed to use. I'm not that MySQL savy. I was following a suggestion to speed up a process. The problems I'm having aren't in the same table and I was was just trying to cover any changes since the problems began.
I ran mysqlcheck on the database and got an OK on all tables. Must be something else.
Thanks!!
-- Alan Sparks, UNIX/Linux Systems Integration and Administration asparks@doublesparks.net
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
-
Alan Sparks -
Mark Richards -
Thomas E Dukes