WP : Admin log impossible

If you are changing table prefixes for a site, then remember to alter the table prefix in the usermeta tables as well. This will allow the new site to properly recognize user permissions from the old site.

UPDATE `newprefix_usermeta` SET `meta_key` = REPLACE( `meta_key` , 'oldprefix_', 'newprefix_' );

Requête complémentaire

UPDATE `newprefix_options` SET `option_name` = REPLACE( `option_name` , 'oldprefix_', 'newprefix_' );