Joshua Adrian joshuaadrian

joshuaadrian / WordPress DB Search and Replace Script v2.1.1

Created October 23, 2013 18:09

 <?php
 /**
  *
  * Safe Search and Replace on Database with Serialized Data v2.1.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.

joshuaadrian / htaccess 301 url redirect

Created October 23, 2013 15:52

RewriteRule ^this/that\.html$ http://www.something.com/that/ [R=301,L]

joshuaadrian / mysqldump dump structure only

Created October 23, 2013 15:49

mysqldump -u username -h localhost --no-data -p database_name > database_dump_name.sql

joshuaadrian / mysqldump dump data only

Last active December 26, 2015 08:19

mysqldump -u username -h localhost --skip-triggers --compact --no-create-info database_name > database_dump_name.sql -p

joshuaadrian / htaccess 301 domain redirect

Last active December 25, 2015 19:19

	RewriteBase /
	RewriteCond %{HTTP_HOST} !oldexample.com$ [NC]
	RewriteRule ^(.*)$ http://newexample.com/$1 [L,R=301]

joshuaadrian / Bash Profile

Created September 5, 2013 13:47

Colored Bash profile with git/hg branch names. Place in your .bash_profile file.