Due to the hassle that my previous host caused me, I was forced to change servers and restore my WordpRess data from a sql file. During the migration I decided to use a different prefix for the WordPress tables but still retaining my data. To do this you’ll need to update 2 tables; below is the sql statement I used.
UPDATE `CHANGE_usermeta` SET `meta_key` = REPLACE( `meta_key` , 'wp_', 'CHANGE_' ); UPDATE `CHANGE_options` SET `option_name` = 'CHANGE_user_roles' WHERE `option_name` ='wp_user_roles' AND `blog_id` =0;
Just replace CHANGE_ with the prefix you desire. Do note that this assumes the the current table prefix is wp_.
