Cloning civicrm / wordpress to dev

Sometimes you need to run some sql queries to clear out the settings from the source server:

CiviCRM database:

delete from civicrm_setting where name = 'wpLoadPhp';

WP database: - Prefix wp_ may differ on some sites. - Base URL http://example.l/ will differ on each site.

delete from wp_options where option_name ='upload_path';
update wp_options set option_value = 'http://example.l/' where option_name in ('siteurl', 'home');