Change DB-Präfix

  • Resolved schwarzpunkt

    (@schwarzpunkt)


    3 years, 6 months ago

    Hi there

    I run in an error after i moved website to another hosting partner. The fail was, because I changed the db-prefix. After that, the memberlist doesn’t show any member anymore. After I changed prefix to the value I had before, the memberlist work as expectet again. I got several hours to find this… And rechecked now with https://ww.wp.xz.cn/plugins/brozzme-db-prefix-change/.

    So, if anybody run in this, just change the db-prefix to the value before…

    Maybe plugin developpers can solve this issue in a future update.

    Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Aswin Giri

    (@aswingiri)

    3 years, 6 months ago

    Hello @schwarzpunkt

    Just changing DB prefix on database tables and wp-config.php file is not enough, WordPress saves some of the metadata using DB prefix which should also be changed when you change the database prefix, for example: {prefix}_capabilities this is used to save user role and capabilities.

    We do not recommend changing the DB prefix afterward.

    Thread Starter schwarzpunkt

    (@schwarzpunkt)

    3 years, 6 months ago

    Thanks for reaching out. Never saw this before, that prefix is used for db field names. Now I will take care of this.

    Plugin Support andrewshu

    (@andrewshu)

    3 years, 4 months ago

    Hi @schwarzpunkt

    This thread has been inactive for a while so we’re going to go ahead and mark it Resolved.

    Please feel free to re-open this thread if any other questions come up and we’d be happy to help. 🙂

    Regards

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Change DB-Präfix’ is closed to new replies.