ianthekid

<div id='woobox-root'></div>
<script>(function(d, s, id) {
  var js, fjs = d.getElementsByTagName(s)[0];
  if (d.getElementById(id)) return;
  js = d.createElement(s); js.id = id;
  js.src = "//woobox.com/js/plugins/woo.js";
  fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'woobox-sdk'));</script>

ianthekid

/*
* Export database
*/

mysqldump -u $username -p -h $host $database > database_backup.sql



/*
* Import database

ianthekid

/*
* Create multi-part archive of ./www/
*/

tar czf - www|split -b 1073741824 - www_backup.tar.



/*
* Extract multi-part archive

ianthekid

/*
* Cron job: Backup database
* Works with cPanel Cron Scheduler
*/


mysqldump -u $user -p$password -h $dbhost $database > /path/to/db_bak_`date +\%Y\%m\%d`.sql

ianthekid

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

ianthekid

/*
 * Wordpress Staging/Development
 */ 

UPDATE wp_options SET option_value = REPLACE(option_value, 'ORIGINAL_URL', 'NEW_URL');

UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'ORIGINAL_URL', 'NEW_URL');

UPDATE wp_posts SET guid = REPLACE(guid, 'ORIGINAL_URL', 'NEW_URL');

ianthekid

SELECT *
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL

ianthekid

find . -type d -exec chmod 755 {} + ; find . -type f -exec chmod 644 {} +

ianthekid

@media only screen and (-webkit-min-device-pixel-ratio: 2) {

.bg {
  background-attachment: scroll !important;
}

}

ianthekid

git fetch
git rebase origin/master


#Source: http://stackoverflow.com/questions/7200614/how-to-merge-remote-master-to-local-branch

#git merge branchname takes new commits from the branch branchname, and adds them to the current branch. If necessary, it automatically adds a "Merge" commit on top.

#git rebase branchname takes new commits from the branch branchname, and inserts them "under" your changes. More precisely, it modifies the history of the current branch such that it is based on the tip of branchname, with any changes you made on top of that.