[CentOS] OT: MySQL Help

Thomas E Dukes

edukes at alltel.net
Wed May 10 00:42:22 UTC 2006


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





More information about the CentOS mailing list