Arvind Shrivastwa arvindsvt

php Developer

arvindsvt / find-replace-sql-wp.sql

Created June 8, 2016 17:18 — forked from celsofabri/find-replace-sql-wp.sql

SQL Query para fazer um simples localizar e substituir / SQL Query to do a simple find and replace

 UPDATE wp_posts SET guid = replace(guid, 'http://olddomain.com','http://newdomain.com');
 UPDATE wp_posts SET post_content = replace(post_content, 'http://olddomain.com', 'http://newdomain.com');
 UPDATE wp_links SET link_url = replace(link_url, 'http://olddomain.com', 'http://newdomain.com');
 UPDATE wp_links SET link_image = replace(link_image, 'http://olddomain.com', 'http://newdomain.com');
 UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://olddomain.com', 'http://newdomain.com');
 UPDATE wp_usermeta SET meta_value = replace(meta_value, 'http://olddomain.com', 'http://newdomain.com');
 /*UPDATE wp_options SET option_value = replace(option_value, 'http://olddomain.com', 'http://newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl' OR option_name = 'widget_text' OR option_name = 'dashboard_widget_options';*/
 UPDATE wp_options SET option_value = replace(option_value, 'http://olddomain.com', 'http://newdomain.com');

arvindsvt / safesearchreplace.php

Created June 8, 2016 17:18 — forked from marke123/safesearchreplace.php

safe search and replace

	<?php

	// Safe Search and Replace on Database with Serialized Data v2.0.0

	// This script is to solve the problem of doing database search and replace
	// when developers have only gone and used the non-relational concept of
	// serializing PHP arrays into single database columns. It will search for all
	// matching data on the database and change it, even if it's within a serialized
	// PHP array.

arvindsvt / wp-modifydb.php

Created June 8, 2016 17:16 — forked from jcanfield/wp-modifydb.php

Serialized PHP Search and Replace

	<?php
	/**
	*
	* Safe Search and Replace on Database with Serialized Data v2.0.1
	*
	* This script is to solve the problem of doing database search and replace when
	* developers have only gone and used the non-relational concept of serializing
	* PHP arrays into single database columns. It will search for all matching
	* data on the database and change it, even if it's within a serialized PHP
	* array.

arvindsvt / wpsearchreplace.php

Created June 8, 2016 17:15 — forked from djaney/wpsearchreplace.php

Used when transferring WP sites. Replace database entries.

	<?php

	// Safe Search and Replace on Database with Serialized Data v1.0.1

	// This script is to solve the problem of doing database search and replace
	// when developers have only gone and used the non-relational concept of
	// serializing PHP arrays into single database columns. It will search for all
	// matching data on the database and change it, even if it's within a serialized
	// PHP array.