david
768dbe0a2d
git-svn-id: https://192.168.0.254/svn/Proyectos.ASong2U_Web/trunk@6 cd1a4ea2-8c7f-e448-aada-19d1fee9e1d6
1 line
1.0 KiB
SQL
1 line
1.0 KiB
SQL
UPDATE wp_posts SET guid = replace(guid, 'http://127.0.0.1:4001/wordpress','http://www.maquetaweb.ws/asong2u');
|
|
|
|
UPDATE wp_posts SET post_content = replace(post_content, 'http://127.0.0.1:4001/wordpress', 'http://www.maquetaweb.ws/asong2u');
|
|
UPDATE wp_posts SET guid = REPLACE (guid, 'http://127.0.0.1:4001/wordpress', 'http://www.maquetaweb.ws/asong2u') WHERE post_type = 'attachment';
|
|
|
|
UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://127.0.0.1:4001/wordpress', 'http://www.maquetaweb.ws/asong2u');
|
|
UPDATE wp_options SET option_value = replace(option_value, 'http://127.0.0.1:4001/wordpress', 'http://www.maquetaweb.ws/asong2u') WHERE option_name = 'home' OR option_name = 'siteurl';
|
|
|
|
/* Borrar revisiones */
|
|
DELETE a,b,c FROM wp_posts a
|
|
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
|
|
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
|
|
WHERE a.post_type = 'revision';
|
|
|
|
TRUNCATE `wp_bp_activity` ;
|
|
TRUNCATE `wp_bp_activity_meta` ;
|
|
TRUNCATE `wp_bp_friends` ;
|
|
TRUNCATE `wp_bp_groups` ;
|
|
TRUNCATE `wp_bp_groups_groupmeta` ;
|
|
TRUNCATE `wp_bp_xprofile_data`; |