MySQL problem

  • anatman

    (@anatman)


    19 years, 3 months ago

    Help please!
    I was looking at the database (through MySQLAdmin) to learn something, when i accidentally pressed a “T” button when viewing a table (comment_content). I think that altered something, as the MySQLAdmin interface replied this:

    One index was added to comment_content (0 queries o.1038 seconds)
    SQL command:
    ALTER TABLE wp_comments ADD FULLTEXT (
    comment_content
    )

    Have i broken something? How can undo this? I am afraid this will bring doom in future upgrade to WP or something. And yes, i have a backup, but it is a little old, i will loose a lot of comments and a few posts if i restore it (i know, iknow…).

Viewing 2 replies - 1 through 2 (of 2 total)
  • Mark (podz)

    (@podz)

    19 years, 3 months ago

    Me no expert.

    Adding something is never as bad as removing, and WP will not use a table that it’s not meant to.
    If this were mine, I’d backup.
    Then try to delete that index
    or
    If I were cautious, I’d leave alone and tell myself to never use my real db for anything 🙂

    I think you’ll be fine.

    Thread Starter anatman

    (@anatman)

    19 years, 3 months ago

    thanks, i found the way to delete the index, and all is still working fine. Anyway i have a backup now…

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘MySQL problem’ is closed to new replies.