Support » Plugins » Search and Replace in the Database

  • I want to extend the 55 character limit that is set in the database… but I don’t know anything / enough about MySQL to get in there, find it, and change it.

    Is there a plug-in, or a way, to search and replace the “55” limit from within the WP admin?

    Or how’s the best way to do this?

Viewing 4 replies - 1 through 4 (of 4 total)
  • whooami

    (@whooami)

    Member

    You want to extend the 55 char limit for what?

    So that I can have things entered in that are longer than 55 characters. 🙂

    Basically it comes down to 55 characters is limiting… it’s a fine limit for most people 99.999% of the time. But, in my case, I need to be able to have much longer sets of data be allowed.

    The only field in the database that has a 55 char limit is the term name, so it is easy enough to manually change it in phpMyAdmin.

    Or you can run the following query in phpMyAdmin. (Change wp_ to whatever prefix you have set.)

    “ALTER TABLE wp_terms CHANGE name name VARCHAR( 255 ) NOT NULL”

    I don’t know what result it would have, so I’m not going to suggest doing it though.

    Thanks Aaron.
    I may try it… (will back up first of course).
    I’m still not sure this is what’s causing my problem though…

    Thanks again!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Search and Replace in the Database’ is closed to new replies.