Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. UPDATE `newprefix_usermeta` SET `meta_key` = REPLACE( `meta_key`, 'wp_', 'newprefix_' )
  2. UPDATE `newprefix_options` SET `option_name` = REPLACE( `option_name` , 'wp_', 'newprefix_' ) WHERE `option_name` LIKE '%wp_%'