WordPress.org

Ready to get started?Download WordPress

Forums

MySQL problem (3 posts)

  1. anatman
    Member
    Posted 9 years 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...).

  2. Mark (podz)
    Support Maven
    Posted 9 years 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.

  3. anatman
    Member
    Posted 9 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.