The MU forums have moved to WordPress.org

Database mass-manipulation (5 posts)

  1. Bruz
    Member
    Posted 17 years ago #

    Hi,

    I think this is a general question for people running MU:

    I'd like to change in all blogs the standard-cat "uncategorized" in "somethingelse" and really don't want to do this one by one via phpmyadmin.

    Which query do I need to change this for every single blog?

    thx, Bruz

  2. Ovidiu
    Member
    Posted 17 years ago #

    well you could run it through phpmyadmin saying: replace every uncategorized with categorized,its not one by one, its just one run :-)

  3. quenting
    Member
    Posted 17 years ago #

    I think you'd need one query per table, which is the why of Bruz's question.
    You'll need a script to do it.

  4. Bruz
    Member
    Posted 17 years ago #

    Ovidiu: yea, thats what I want - but HOW? :-) and

    quenting: you're right - I'd like to do it db-wide. I think Ovidiu got the point, but I need the HOW :-)

  5. Ovidiu
    Member
    Posted 17 years ago #

    I might make a complete idiot out of myself, but wouldn't a plugin like this do what you want: http://www.urbangiraffe.com/plugins/search-regex

    mind though I did not test it, I just knew about it and there are several others doing the same thing, like: http://thedeadone.net/software/search-and-replace-wordpress-plugin/

About this Topic