BEGIN;

DELETE FROM `wp_options` WHERE option_name LIKE '_transient_%';

DELETE FROM `wp_ak_twitter`;

UPDATE wp_options set option_value="http://localhost/~ymh/site_iri_wp/" where option_name = "siteurl";

UPDATE wp_posts SET guid = replace(guid, 'http://www.iri.centrepompidou.fr/dev/~hurons/',

   'http://localhost/~ymh/site_iri_wp/');

UPDATE wp_options SET option_value = replace(option_value,'http://www.iri.centrepompidou.fr/dev/~hurons/', 'http://localhost/~ymh/site_iri_wp/') WHERE option_name = 'sm_status';

UPDATE wp_options SET option_value = replace(option_value,'/iridata/users/hurons/public_html/', '/Users/ymh/dev/workspace/site_iri_wordpress/web/') WHERE option_name = 'sm_status';

UPDATE wp_options SET option_value = "root@iri.centrepompidou.fr" where option_name = "admin_email";

COMMIT;