Forums

[resolved] [Plugin: WP Security Scan] Table Prefix : extra step (3 posts)

  1. brasofilo
    Member
    Posted 2 years ago #

    not seeing this information here, i'd like to share

    after altering the table prefix, you gotta run this SQL:

    UPDATE MYNEWPREFIX_usermeta SET meta_key = REPLACE( meta_key , 'wp_', 'MYNEWPREFIX_' );

    don't remember where i found the solution... too much code these days... but i've been replacing various table prefixes without trouble

    http://wordpress.org/extend/plugins/wp-security-scan/

  2. tglassey
    Member
    Posted 2 years ago #

    Remember to change the MYNEWPREFIX to whatever you changed the new prefix to from "wp_"

  3. kvnkim
    Member
    Posted 1 year ago #

    LIFE SAVER! Thank you so much.

Topic Closed

This topic has been closed to new replies.

About this Topic